-
Originally Posted by tarana
can u explain the process of creating database by using DBCA
What's wrong with Oracle documentation? http://download.oracle.com/docs/cd/B...install003.htm
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
But Pablo, that would require thinking and a little work...
-
Please Seniors,, why u leaders making confusion in this issue,, please give me a straight answer to over come this undo tablespace.
-
Originally Posted by 4iappsDBA
Please Seniors,, why u leaders making confusion in this issue,, please give me a straight answer to over come this undo tablespace.
Make sure that the undo tablespace specified in you init/spfile points to your undo tablespace.
-
Undo Problem Solved
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|