Home » RDBMS Server » Server Utilities » Cross platform export
Cross platform export [message #247275] Mon, 25 June 2007 05:57 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: Cross platform export [message #247281 is a reply to message #247275] Mon, 25 June 2007 06:18 Go to previous messageGo to next message
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
Re: Cross platform export [message #247283 is a reply to message #247281] Mon, 25 June 2007 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And grant him quota on the tablespace otherwise he won't be able to create objects in it.

Regards
Michel
Re: Cross platform export [message #247303 is a reply to message #247275] Mon, 25 June 2007 08:15 Go to previous message
arijitnit
Messages: 3
Registered: June 2007
Junior Member
Thank you very much..My headahe is gone..
Previous Topic: ORA-00942: table or view does not exist
Next Topic: Oracle 8i import problem
Goto Forum:
  


Current Time: Sun Dec 11 04:17:29 CST 2016

Total time taken to generate the page: 0.10840 seconds