| New databsae in exsisting db server [message #306359] |
Thu, 13 March 2008 20:34  |
caprikar
Messages: 226
Registered: March 2007
|
Senior Member |
|
|
Hi,
I have a database PRODCIM in a server(Sun Solaris 5. with characterset WE8ISO8859P1, I want to create another database TEMP with characterset UTF8 and export all schemas except default users created during database creation and import it into TEMP databse and then shutdown PRODCIM and rename TEMP database into PRODCIM by creating a control file using alter databse backup control file to trace and edit the file with new path.
My question is:
In PRODCIM the path of the data files are:
/u01/app/oracle/prodcim
/u02/app/oracle/prodcim
When I create TEMP database, can I create another directory /u01/app/oracle/PRODCIM and /u01/app/oracle/PRODCIM and keep all the TEMP database related files under that directory? I just want to make sure this will not cause any problem to the oraiginal database PRODCIM.
Also I have the following users:
ANONYMOUS,CTXSYS,DBSNMP,DIP,DMSYS,EXFSYS,MDSYS,OLAPSYS,ORDSYS,SYS,SYSMAN,SYSTEM,TEMP,WKSYS,WMSYS,XDB
Are all these users are created during database creation? or any of them are user created schema?
Thanks.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
