Home » RDBMS Server » Server Utilities » export import in oracle9i (oracle9i)
icon4.gif  export import in oracle9i [message #311676] Sat, 05 April 2008 12:23 Go to next message
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???
Re: export import in oracle9i [message #311678 is a reply to message #311676] Sat, 05 April 2008 12:43 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
To export

exp system/password full=y


to import

imp system/password full=y

Re: export import in oracle9i [message #311679 is a reply to message #311676] Sat, 05 April 2008 12:50 Go to previous messageGo to next message
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.
Re: export import in oracle9i [message #311681 is a reply to message #311678] Sat, 05 April 2008 13:00 Go to previous messageGo to next message
jatin arora
Messages: 6
Registered: April 2008
Location: delhi
Junior Member
my software says that exp is not a recognize command
Re: export import in oracle9i [message #311682 is a reply to message #311679] Sat, 05 April 2008 13:01 Go to previous messageGo to next message
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..
Re: export import in oracle9i [message #311683 is a reply to message #311682] Sat, 05 April 2008 13:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you at least install Oracle on your PC?

Regards
Michel
Re: export import in oracle9i [message #311684 is a reply to message #311676] Sat, 05 April 2008 13:05 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Have you installed oracle to the other PC?
Have you created the database?
Re: export import in oracle9i [message #311686 is a reply to message #311684] Sat, 05 April 2008 13:12 Go to previous messageGo to next message
jatin arora
Messages: 6
Registered: April 2008
Location: delhi
Junior Member
yes i have already done that.
Re: export import in oracle9i [message #311687 is a reply to message #311686] Sat, 05 April 2008 13:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: export import in oracle9i [message #311735 is a reply to message #311687] Sun, 06 April 2008 05:27 Go to previous messageGo to next message
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??
Re: export import in oracle9i [message #311736 is a reply to message #311676] Sun, 06 April 2008 05:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Read Oracle Database Utilities Document. It is found in tahiti.oracle.com
Re: export import in oracle9i [message #311738 is a reply to message #311735] Sun, 06 April 2008 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: export import in oracle9i [message #311958 is a reply to message #311735] Mon, 07 April 2008 09:06 Go to previous message
joy_division
Messages: 4640
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.
Previous Topic: expdp - error
Next Topic: Loading clob data in Table by using sql loader
Goto Forum:
  


Current Time: Sat Dec 03 22:03:40 CST 2016

Total time taken to generate the page: 0.10982 seconds