OraFAQ Forum: Server Utilities » export import in oracle9i

Home » RDBMS Server » Server Utilities » export import in oracle9i (oracle9i)

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

export import in oracle9i [message #311676]

Sat, 05 April 2008 12:23

jatin arora
Messages: 6
Registered: April 2008
Location: delhi

Junior Member

how to export and import in oracle9i.
i have to transfer my database from 1pc to another but don't know how to??
i have tried EXP but i am not sure how to use it???

Report message to a moderator

Re: export import in oracle9i [message #311678 is a reply to message #311676]

Sat, 05 April 2008 12:43

varu123
Messages: 754
Registered: October 2007

Senior Member

To export

exp system/password full=y

to import

imp system/password full=y

Report message to a moderator

Re: export import in oracle9i [message #311679 is a reply to message #311676]

Sat, 05 April 2008 12:50

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you want to copy the whole database, then if you can take the database down, I'd suggest doing a cold backup and copying all the files to the new node.

Report message to a moderator

Re: export import in oracle9i [message #311681 is a reply to message #311678]

Sat, 05 April 2008 13:00

jatin arora
Messages: 6
Registered: April 2008
Location: delhi

Junior Member

my software says that exp is not a recognize command

Report message to a moderator

Re: export import in oracle9i [message #311682 is a reply to message #311679]

Sat, 05 April 2008 13:01

jatin arora
Messages: 6
Registered: April 2008
Location: delhi

Junior Member

i do not know how to do that??
can you explain it in a bit detail..

Report message to a moderator

Re: export import in oracle9i [message #311683 is a reply to message #311682]

Sat, 05 April 2008 13:04

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you at least install Oracle on your PC?

Regards
Michel

Report message to a moderator

Re: export import in oracle9i [message #311684 is a reply to message #311676]

Sat, 05 April 2008 13:05

varu123
Messages: 754
Registered: October 2007

Senior Member

Have you installed oracle to the other PC?
Have you created the database?

Report message to a moderator

Re: export import in oracle9i [message #311686 is a reply to message #311684]

Sat, 05 April 2008 13:12

jatin arora
Messages: 6
Registered: April 2008
Location: delhi

Junior Member

yes i have already done that.

Report message to a moderator

Re: export import in oracle9i [message #311687 is a reply to message #311686]

Sat, 05 April 2008 13:17

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you have imp program in %ORACLE_HOME%\bin directory.
just set PATH, ORACLE_HOME and ORACLE_SID variables to the correct value.

Regards
Michel

Report message to a moderator

Re: export import in oracle9i [message #311735 is a reply to message #311687]

Sun, 06 April 2008 05:27

jatin arora
Messages: 6
Registered: April 2008
Location: delhi

Junior Member

how can i get 'create session' previlege for being able t use exp.i have already created a user but it doesn't have the previleges to run catexp.sql and it keeps giving me errors.

this is not my default user ,so i have to use deafult user for export or can i use this user only??
even my system login gives error while running these scripts.

and after i have exported the file how do i import it in another system??
do i have to use different keywords for importing the file.
if yes,how??

Report message to a moderator

Re: export import in oracle9i [message #311736 is a reply to message #311676]

Sun, 06 April 2008 05:37

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Read Oracle Database Utilities Document. It is found in tahiti.oracle.com

Report message to a moderator

Re: export import in oracle9i [message #311738 is a reply to message #311735]

Sun, 06 April 2008 05:45

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

.i have already created a user but it doesn't have the previleges to run catexp.sql and it keeps giving me errors.

Stop immediatly to do anything on your database.
You lack the basics.
Read the documents, Database Concepts, Administrator's guide and Database Utilities.
The only thing you are doing now is to mess your database.

Regards
Michel

Report message to a moderator

Re: export import in oracle9i [message #311958 is a reply to message #311735]

Mon, 07 April 2008 09:06

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

As others have pointed out, you really need to read the documentation before you go any further. You have already probably caused damage to your database with SYS objects now sitting in your schema.

Just to note, although I hesitate to offer this being that you might "run with it" and cause even more harm, but scripts such as catexp.sql run as the SYS user. Reading the documentation is of utmost importance here.

Report message to a moderator

Previous Topic:	expdp - error
Next Topic:	Loading clob data in Table by using sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 17:00:48 CST 2025