Home » RDBMS Server » Server Administration » How to copy the Oracle database structure to new server? (Oracle 9i, Window Server)
How to copy the Oracle database structure to new server? [message #438362] Fri, 08 January 2010 05:50 Go to next message
momer79
Messages: 12
Registered: January 2010
Junior Member
Hi,

I am using Oracle 9i on development server and want to copy the all database structure to the new oracle server.

Both server are using oracle 9i and window server.

On development server If i run following query then it brings 19 rows.
- select * from dba_data_files order by tablespace_name;

And this query returns 257 rows.
select * from sys.v_$parameter;

Is there a way to just copy a database structure (without data) to new server? instead of manually defining all parameters, storage space and etc?

Thanks

Re: How to copy the Oracle database structure to new server? [message #438366 is a reply to message #438362] Fri, 08 January 2010 06:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Database structure, in most cases means table structure and other objects.
Do you want to copy all objects without data?
You can export and import.

>>instead of manually defining all parameters, storage space and etc?
Not sure what you mean.
You can "logically" export and import just structure.
In target you need "some storage".
Re: How to copy the Oracle database structure to new server? [message #438367 is a reply to message #438366] Fri, 08 January 2010 06:23 Go to previous messageGo to next message
momer79
Messages: 12
Registered: January 2010
Junior Member
Hi,

Yes i like to copy all table structure and objects.

In Oracle development server there are 37 Schemas and there are total 1100 tables in those 37 schemas.

In new machine i haven't created anything apart from installing Oracle 9i.

So import and export would be a best option?

Is there anyway if i just copy all necessary files ( parameter file, Control file) from development server to new machine for copying database structure?

Thanks

[Updated on: Fri, 08 January 2010 06:24]

Report message to a moderator

Re: How to copy the Oracle database structure to new server? [message #438371 is a reply to message #438367] Fri, 08 January 2010 07:21 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is there anyway if i just copy all necessary files ( parameter file, Control file) from development server to new machine for copying database structure?
That is what we call a "cold copy".
You shutdown the database and copy all related files physically.
With logical export/import, you copy just the data.
You precreate the database in target, precreate the tablespaces as in source, export whole database and import.
Please search this forum for cold copy/export and import.

http://www.orafaq.com/wiki/Import_Export_FAQ
http://www.pgts.com.au/pgtsj/pgtsj0211b.html
Previous Topic: Connect to Specific instance
Next Topic: Startup Problem- Control File Error
Goto Forum:
  


Current Time: Sun Dec 04 02:54:53 CST 2016

Total time taken to generate the page: 0.07647 seconds