Home » RDBMS Server » Server Administration » New databsae in exsisting db server
New databsae in exsisting db server [message #306359] Thu, 13 March 2008 20:34 Go to next message
Messages: 226
Registered: March 2007
Senior Member

I have a database PRODCIM in a server(Sun Solaris 5.Cool 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:

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:


Are all these users are created during database creation? or any of them are user created schema?

Re: New databsae in exsisting db server [message #306361 is a reply to message #306359] Thu, 13 March 2008 21:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Re: New databsae in exsisting db server [message #306381 is a reply to message #306359] Fri, 14 March 2008 00:08 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All of them are Oracle users. The are created depending on the options you choose.

Previous Topic: control file and data file recovery
Next Topic: its urgent please
Goto Forum:

Current Time: Fri Jul 28 08:11:31 CDT 2017

Total time taken to generate the page: 0.14109 seconds