OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Ignore=y safety

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

Ignore=y safety [message #246031]

Tue, 19 June 2007 10:53

bank_master
Messages: 73
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

Report message to a moderator

Re: Ignore=y safety [message #246034 is a reply to message #246031]

Tue, 19 June 2007 10:59

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.

Report message to a moderator

Re: Ignore=y safety [message #246040 is a reply to message #246034]

Tue, 19 June 2007 11:11

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

bank_master
Messages: 73
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

Report message to a moderator

Re: Ignore=y safety [message #246060 is a reply to message #246031]

Tue, 19 June 2007 12:44

bank_master
Messages: 73
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