Home » RDBMS Server » Backup & Recovery » creating test database (oracle 9i)
creating test database [message #420711] Tue, 01 September 2009 13:53 Go to next message
shadab
Messages: 4
Registered: August 2009
Location: india
Junior Member
i want to create a test database and a test user and import data from production databse through dump files. please help me how to do this.
Re: creating test database [message #420713 is a reply to message #420711] Tue, 01 September 2009 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 59274
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you know yet?
Do you know how to create a database?
Do you know how to export a database?
Do you know how to backup a database?
Do you know how to restore a database?
Do you know how to duplicate a database?

Regards
Michel
Re: creating test database [message #420714 is a reply to message #420711] Tue, 01 September 2009 14:10 Go to previous messageGo to next message
BlackSwan
Messages: 22837
Registered: January 2009
Senior Member
All answers can be found a few clicks beyond URL below.

http://www.oracle.com/pls/db92/homepage?remark=tahiti

When all else fails, Read The Fine Manuals
Re: creating test database [message #420729 is a reply to message #420713] Tue, 01 September 2009 19:05 Go to previous messageGo to next message
shadab
Messages: 4
Registered: August 2009
Location: india
Junior Member
Michel

I have just created a database using DBCA. But i want learn creating the same using command lines. I have been assigned a task to create a database for testing and it should be loaded with production data dump. So please tell what i need to learn more.

Regards

shadab

[Updated on: Tue, 01 September 2009 19:06]

Report message to a moderator

Re: creating test database [message #420730 is a reply to message #420711] Tue, 01 September 2009 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 22837
Registered: January 2009
Senior Member
>So please tell what i need to learn more.
RMAN
Re: creating test database [message #420736 is a reply to message #420729] Tue, 01 September 2009 22:56 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

I'd suggest you to use DUPLICATE DATABASE command in RMAN to create clone of your database in any host you want

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BRADV169
Re: creating test database [message #420737 is a reply to message #420711] Tue, 01 September 2009 23:12 Go to previous messageGo to next message
BlackSwan
Messages: 22837
Registered: January 2009
Senior Member
>http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BRADV169
Providing URL to V10.2 documentation to the OP running V9 may be less than useful for OP who appears to be documentation challenged.
Re: creating test database [message #420738 is a reply to message #420737] Tue, 01 September 2009 23:17 Go to previous message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

No problem, I can provide 9i documentatoin as well Smile Here it is:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmdupdb.htm
Previous Topic: RMAN Not Removing Obsolete Backups
Next Topic: RMAN-04005: error from target database: ORA-01031: insufficient privileges
Goto Forum:
  


Current Time: Tue Sep 30 07:05:47 CDT 2014

Total time taken to generate the page: 0.06374 seconds