Oracle9i How to convert from undo tables to rollback segments

Advertisement
November 30

Hi,
Anyone try before converting from UNDO management to using rollback segment....What are the procedures for the conversion...
Thank You...

Advertisement

Replay

Hi,
Follow these steps to convert from Auto UNDO to Rollback Segs....
1. With the database opened, create a rollback tablespace and then create some rollback segments and bring them online like this
CREATE ROLLBACK SEGMENT RBS1 TABLESPACE RBS;
ALTER ROLLBACK SEGMENT RBS1 ONLINE;
2. Then edit the PFILE and modify these parameters
Add: ROLLBACK_SEGMENTS=(RBS1,RBS2,RBS3....)
Comment: UNDO_MANAGEMENT=AUTO and UNDO_TABLESPACE=UNDOTBS or whatever name you have for your UNDO tablespace.
3. Shutdown the database gracefully(normal).
4. Startup pfile=<Pfile path>
5. Sync these new parameter changes to the SPFILE by recreating the SPFILE.
6. Take a full level 0 backup of your database as the structure has changed.
The next time you start the database, it will use the SPFILE which is same as the PFILE.
Regards.

View 2 Replies

Transaction table in rollback segments

November 30

hi guys, I have read the following, but am still having a little difficulty conceptualising. Would someone be kind enough to give me a very brief example? thanks For each rollback segment, Oracle maintains a transaction table--a list of all transacti

View All Replies

How to convert from pt to mm

November 30

Dear all, Does anybody know how to convert value of pt to value of mm according to language and font? Thanks a lot! Best regards, Christo Edited by: Christo Tan on Dec 22, 2011 5:51 AM Edited by: Christo Tan on Dec 22, 2011 6:00 AMThe standard system

View All Replies

How to Convert an internal table into Text File

November 30

Hello friends, Can you help me to find out the way to convert an internal table data into a flat file. the problem is that my internal table contains fields with data type INT also.please  go through the code and the parameter passed to the  finction

View All Replies

How to Extract From Pool Tables

November 30

Hi All, Can Somebody help with the Detailed Description how to extract the Data from Pool Tables from ECC to SAP BW Thanks SamOption 1 Create Infoset SQ02  on those tables and RSO2 - create generic ds Option 2 :Create functional Module and create gen

View All Replies

How to convert from Ant project to maven project?

November 30

Hi, all: Sorry for my entry-level question. Is it possible for me to convert from an Ant project to A Maven project from within NetBeans IDE? Or, is there any method to convert from an Ant project to a Maven project using some command line method? Or

View All Replies

Nested Repeat Region (How to convert from table to list)

November 30

Sorry, i am really no PHP hero :-( i created a menu with the "nested repeat region" wizzard. Now i want to change the HTML from TABLE to LIST. I thought i just need to delete <table>- and <td>-tags, replace <tr> with <ul>

View All Replies

How to convert from ASM to regular filesystem

November 30

Hi All, On our RHEL 5.5 machine we have one disk partition managed by ASM (11.2.0.1.0). We wan't to convert it to regular file system. How can we do it? Regards, VinodOpen a Terminal window and paste the following: # su - oracle $ . oraenv ORACLE_SID

View All Replies

How to convert an internal table of char type to Raw (1022 char) format int

November 30

Hi All, I am facing the problem while converting the character type internal table to Raw (1022 char) format internal table. Example : Source : Internal table - Itab_send of type char132. Target : ( Required ) Internal table - itab_receive of type SD

View All Replies

How to convert from Finder Object reference to POSIX path

October 11

I'm new to AppleScript. I'm super close to getting what I need done, but I've ran across a snag in the middle. The error I'm getting is Can’t make quoted form of POSIX path of item 1 of {«class docf» \"filename\" of «class cfol» \"foldernam

View All Replies

Have a 2008 iMac 24".  How to convert from mini-DVI to mini-displayport?

October 11

I bought this awesome device recently: http://www.monoprice.com/products/product.asp?cid=104&cp_id=10428&cs_id=1042802&pid=6331&seq=1&format=2 It takes the TOSLINK audio output and the minidisplayport output and combines it into HDMI t

View All Replies

How to go from Logical Table to Physical Table?

October 11

Hi, I'm start using SQL Data Modeler. In order to create a table in the DB, do I need to copy the ddl generated in the Relational model and run it in the DB? or the data modeler created all objects directly in the DB? Thanks.do I need to copy the ddl

View All Replies

How to sum from multiple tables on one table?

October 11

I have 12 tables covering 4 separate pages in Numbers, with each of the 12 tables summing each row at the bottom of each table. I'd like to take the sums of each of the 12 tables, and sum each of those sums together into one table. For instance, each

View All Replies

How to convert from scientific notations to double value ?

November 30

Hi all, i need to convert a string 2E-23 to corresponding double values so that i can compare it one more existing double value. Is there any API present for this ? Thanks and regards, rosamama.Note: This thread was originally posted in the Swing for

View All Replies

Convert from jchar to char

November 30

Does any one know how to convert from jchar to char? Thank you,does it have to be a jchar or can you get a jstring? is it possible to convert your jchar into a jstring before you pick it up in jni? if you can get a jstring you can use the function co

View All Replies

How to retrieve data from catsdb table and convert into xml using BAPI

November 30

How to retrieve data from catsdb table and convert into xml using BAPI Points will be rewarded, Thank you, Regards, Jagrut BharatKumar ShuklaHi, This is not your requirment but u can try this : CREATE OR REPLACE DIRECTORY text_file AS 'D:\TEXT_FILE\'

View All Replies

How can i convert the data from mutiple-table to the other database(MSSQL)?

October 11

Dears, How can i convert the data from mutiple-table to the other database such as MS-SQL? I have a third party system based on MS-SQL 2000. Now we want to make a integration between SAP R/3(Oracle) and SQL server. When my user releases the purchase

View All Replies

How do I create a Table of Contents in InDesign CS6 for print that easily converts to epub?

October 11

How do I create a Table of Contents in InDesign CS6 for a print book that easily converts to epub?  Can anyone point me to a link for a step-by-step (not a video) on setting up all the elements of a print book properly (pages, table of contents and i

View All Replies

How to Convert internal table data into xml and xml data into internal tab

November 30

Hi Guys,       I have a requirement  that  i have to convert the internal table data into xml format and viceversa . for my requirement  i came to know that i have to use Transformations concept.  i done the converting the data from internal table in

View All Replies

How to convert table content into html format?

November 30

Hi, Experts, How to convert internal data into HTML format is there any function module or piece of code to download content into HTML. Thank u, Shabeer Ahmed.Then use this code.... REPORT  ytest_table_html1. *        D A T A   D E C L A R A T I O N

View All Replies

Tags:

  1. arp mac aging best practices
  2. sony kdl 42w805a netflix problem
  3. descargar iBooks 3.1.1 .ipa
  4. ipad a1396 charging only vibrate no on
  5. imovie program for a1151
  6. A422_000_085_140402_WW_WIFI
  7. segment e1idku4
  8. 7PBZ
  9. throughoutrpq
  10. barnduu
Copyrights 2019 Fcffair BigData Resource, All rights reserved