Copy Oracle Database

Dear all,

I want to copy database or create one same instance of the same database.

In my situations, I have the oracle9i with four database. ( LIVE, DEMO, FIN, SAMPLE) . Now I want to create one more with the name "Test" so that I can access the Test database using VB/ . NEt/ ODBC.

Please tell me the procedures? Or similar document.

Thanks for your big help and attention.

Hi,

I don't understand what you are referring to as instance and what as database. Multiple databases per instance do not exist in oracle (it does in db2 and sql server). if you are referring to a database schema than you can create a user and export the data from your original "database" and import into the newly created "database".
If you are referring to a database you can use backup and restore (the restore will be done into a new name - test).

you need to clearly what you mean.

go to the command prompt, type "dbca", and fill in the prompts. Did you create a template for your databases? select it and create database, do an export/import of the data you want, and you are done ... if you don't have a template, you need to get your database parameters from the data dictionary and init.ora parameters.

Followup ... after double-checking ... forget what I said about not having a template, you can use "dbca" to create a template from your database, even, optionally, with the data. Then you can use this template to make a clone database anywhere you want.