OraFAQ Forum: Server Utilities » Cross platform export

Home » RDBMS Server » Server Utilities » Cross platform export

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

Cross platform export [message #247275]

Mon, 25 June 2007 05:57

arijitnit
Messages: 3
Registered: June 2007

Junior Member

Hi..i am a new user of oracle and I am in opensuse 10.2 using oracle 9.2.0.4
I have created a database named arijit and there I have created a user "Project".I have granted some grants to this user like create session and create sequence and have created some tables in that profile
Now I want to export the full "Project" user to another machine running windows and where the user "Project" does not exist.
What are the tools that I might use? I learnt somewhere that IMP/EXP may cause problem in cross-platform data copy?Is that so??
How should I go on about it?

[Updated on: Mon, 25 June 2007 05:57]

Report message to a moderator

Re: Cross platform export [message #247279 is a reply to message #247275]

Mon, 25 June 2007 06:08

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Export/import is THE geniune crossplatform tool from Oracle.
There is no problem unless you don't use a binary transfer format.

If you export only the schema, you don't have the statements to create it in the export dump file. You have to precreate it in the targer database before your import.

Regards
Michel

Report message to a moderator

Re: Cross platform export [message #247281 is a reply to message #247275]

Mon, 25 June 2007 06:18

arijitnit
Messages: 3
Registered: June 2007

Junior Member

hi,
Thanks for the reply.
So all I have to do is the initialization of the user and setting the default tablespace and grant the create session and create sequence to the user and then import the .dmp file?
regards
Arijit

Report message to a moderator