Home » RDBMS Server » Server Utilities » Ignore=y safety
Ignore=y safety [message #246031] Tue, 19 June 2007 10:53 Go to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

how safe is the usage of the ignore=y parameter on an import if it gives u an error regarding tablespaces already being created
Re: Ignore=y safety [message #246034 is a reply to message #246031] Tue, 19 June 2007 10:59 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
I would say it is virtually standard practice. Most people pre-create tablespaces before running an import. That allows you to create them where you want and with whatever size you want.
Re: Ignore=y safety [message #246040 is a reply to message #246034] Tue, 19 June 2007 11:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
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.


No it will avoid some you errors due to precreation.

Donot post across..

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

Report message to a moderator

Re: Ignore=y safety [message #246056 is a reply to message #246040] Tue, 19 June 2007 12:10 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

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
Re: Ignore=y safety [message #246060 is a reply to message #246031] Tue, 19 June 2007 12:44 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

Import returned tablespaces already created and terminated unsuccessfuly, so i would like ot know if by usinig the ignore=y parameter i will have a safe import

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

Report message to a moderator

Re: Ignore=y safety [message #246061 is a reply to message #246060] Tue, 19 June 2007 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
icon10.gif  Re: Ignore=y safety [message #246246 is a reply to message #246061] Wed, 20 June 2007 07:24 Go to previous message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

hi thanks for the help everything worked out smoothly so far
Previous Topic: Re: How to do a full export/import
Next Topic: Indexes
Goto Forum:
  


Current Time: Thu Dec 08 16:19:28 CST 2016

Total time taken to generate the page: 0.05863 seconds