OraFAQ Forum: Server Utilities » how export and import oracle database 9i

Home » RDBMS Server » Server Utilities » how export and import oracle database 9i

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

how export and import oracle database 9i [message #74472]

Fri, 17 December 2004 05:15

Mohan G
Messages: 36
Registered: August 2004

Member

hello

i am new to use oracle database.how can i export my database�and create the same database in another server ?

please help me how to use exp/imp utilities ...

shall i need to drop the previous tables,schemas, indexes (in the destination server)?

thanking you

Mohan G

Report message to a moderator

Re: how export and import oracle database 9i [message #74473 is a reply to message #74472]

Fri, 17 December 2004 06:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.net/faqiexp.htm

Report message to a moderator

Re: how export and import oracle database 9i [message #74478 is a reply to message #74473]

Fri, 17 December 2004 22:45

Mohan G
Messages: 36
Registered: August 2004

Member

i have tried that method but i couldn't see any file in the orahome/bin directory.

can i create a script file specifing the location where to save and take this script file and run on the destination server ?
can you please give any example ?

thank you

Report message to a moderator

Re: how export and import oracle database 9i [message #74479 is a reply to message #74478]

Fri, 17 December 2004 22:47

Mohan G
Messages: 36
Registered: August 2004

Member

i need to transfer the sctructure with all the structrues attributes like (constraints, indexes,triggers, stored procedures ..)

Report message to a moderator

Re: how export and import oracle database 9i [message #74480 is a reply to message #74479]

Sat, 18 December 2004 00:55

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

exp/imp tools would be present in $ORACLE_HOME/bin.
Make sure you have $ORACLE_HOME/bin in your path.

Take a full database export from sourcedb.
Create a new database (targetDB)
establish tnsconnections to talk to targetDB.
Precreate the tablespaces in targetDB as in sourceDB.
do a full database import.
or
do it user-by-user ( gives much control).
use fromuser/touser clause.

First read the documentation. Gives a great wealth of information.

Report message to a moderator

Previous Topic:	Oracle table import fails
Next Topic:	Re: FREE OCP PAPERS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:10:03 CDT 2024