What's wrong with Oracle documentation? http://download.oracle.com/docs/cd/B...install003.htm
What's wrong with Oracle documentation? http://download.oracle.com/docs/cd/B...install003.htm
Please Seniors,, why u leaders making confusion in this issue,, please give me a straight answer to over come this undo tablespace.
Yes you are correct just now i did and its working fine..
i would like to post the database creation syntax here, please dont mine.
its just to upcome from UNDO TABLESPACE problem in common.
1) In "init.ora" file please set the UNDO TABLESPACE name and keep it on ur mind.
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
UNDO_TABLESPACE=UNDOTBS1
2) Type creation commands in a notepad which will helps you to write it without any wrong spells,directory paths and commas(').
3) Here u have to remember the UNDO TABLESPACE NAME u given in "init.ora" file, and specify the same in the line "undo tablespace UNDOTBS1"
For u reference here am giving a sample prg.
create database iapps
logfile group 1 'C:/oracle/product/10.2.0/oradata/iapps/redo1.log' size 10m,
group 2 'C:/oracle/product/10.2.0/oradata/iapps/redo2.log' size 10m,
group 3 'C:/oracle/product/10.2.0/oradata/iapps/redo3.log' size 10m
datafile 'C:/oracle/product/10.2.0/oradata/iapps/system.dbf' size 50m autoextend on
next 2m maxsize 90m
sysaux datafile 'C:/oracle/product/10.2.0/oradata/iapps/sysaux.dbf' size 25m autoextend on
next 1m maxsize 40m
undo tablespace UNDOTBS1
datafile 'C:/oracle/product/10.2.0/oradata/iapps/undo.dbf' size 10m
default temporary tablespace temp
tempfile 'C:/oracle/product/10.2.0/oradata/iapps/temp.dbf' size 10m
I Hope this will help ever new junior DBA's