OraFAQ Forum: Server Administration » How to copy the Oracle database structure to new server?

Home » RDBMS Server » Server Administration » How to copy the Oracle database structure to new server? (Oracle 9i, Window Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to copy the Oracle database structure to new server? [message #438362]

Fri, 08 January 2010 05:50

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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".

Report message to a moderator

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

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

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Previous Topic:	Connect to Specific instance
Next Topic:	Startup Problem- Control File Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:47:35 CDT 2024