Home » RDBMS Server » Server Utilities » Re: How to do a full export/import
Re: How to do a full export/import [message #72654] Mon, 18 August 2003 06:35 Go to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please refere oracle documentation ( utilities manual)
in tahiti.oracle.com
or
technet.oracle.com/docs
all you need is a free account
Re: How to do a full export/import [message #72724 is a reply to message #72654] Sat, 04 October 2003 02:26 Go to previous messageGo to next message
sitapatirao
Messages: 1
Registered: October 2003
Junior Member
how to export/import oracle database from ones own pc to a remote one or vice-versa?
give stepwise solution.
Re: How to do a full export/import [message #246014 is a reply to message #72654] Tue, 19 June 2007 10:18 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

would anybody recommend using the ignore=y is there any drawbacks of using this parameter
Re: How to do a full export/import [message #246017 is a reply to message #72724] Tue, 19 June 2007 10:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
sitapatirao wrote on Sat, 04 October 2003 01:26
how to export/import oracle database from ones own pc to a remote one or vice-versa?
give stepwise solution.



You means network IMP/EXP??

Or you just take it on actual and then by scp/ftp transfer it to there.
Re: How to do a full export/import [message #246019 is a reply to message #246014] Tue, 19 June 2007 10:24 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
bank_master wrote on Tue, 19 June 2007 09:18
would anybody recommend using the ignore=y is there any drawbacks of using this parameter



When tables are manually created before data is imported,
the CREATE TABLE statement in the export dump file will fail
because the table already exists. To avoid this failure and continue
loading data into the table, set the import parameter IGNORE=y.
Otherwise, no data will be loaded into the table because of the table
creation error.
Re: How to do a full export/import [message #246044 is a reply to message #72654] Tue, 19 June 2007 11:31 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
DreamzZ,

Rhetorical question -

Do you honestly think OP [sitapatirao wrote on Sat, 04 October 2003 01:26] will benefit from your response after 3+ years?
Re: How to do a full export/import [message #246047 is a reply to message #246044] Tue, 19 June 2007 11:34 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
hahaha
How man you check that dates.when i entered the forum it was red i thought might be some 1 post today.

so stupid i am Embarassed
Re: Ignore=y safety [message #246057 is a reply to message #72654] Tue, 19 June 2007 12:16 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
thing is i did a full export of the database so as to move it to a new machine and the database was created on the new machine and tablespaces created but on importing the dumps errors were encountered whereby it was sasid that the tablespaces were already created


Post errors logs.Did you Import data Successfully or it terminate unsuccesfully?

[Updated on: Tue, 19 June 2007 12:17]

Report message to a moderator

Previous Topic: SQL Loader + position
Next Topic: Ignore=y safety
Goto Forum:
  


Current Time: Sun Dec 04 20:43:25 CST 2016

Total time taken to generate the page: 0.20050 seconds