OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import undo (How make that import don't create undo?)

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

Import undo [message #275710]

Mon, 22 October 2007 08:22

thorin666
Messages: 144
Registered: March 2007

Senior Member

Hi, i want to know if someone have the way to import don't create undo ? i found -ignore but i don't know if that option is correct
using imp help=yes i didn't find anyother option that told me something like this
thnx a lot

Report message to a moderator

Re: Import undo [message #275713 is a reply to message #275710]

Mon, 22 October 2007 08:34

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

Senior Member
Account Moderator

No way.

Regards
Michel

Report message to a moderator

Re: Import undo [message #275714 is a reply to message #275713]

Mon, 22 October 2007 08:38

thorin666
Messages: 144
Registered: March 2007

Senior Member

And rman does generate undo?

Report message to a moderator

Re: Import undo [message #275719 is a reply to message #275714]

Mon, 22 October 2007 08:59

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

Senior Member
Account Moderator

No.

Regards
Michel

Report message to a moderator

Re: Import undo [message #278492 is a reply to message #275710]

Sun, 04 November 2007 13:59

seethem
Messages: 41
Registered: September 2007

Member

Hey man,

I think that you can execute,

'alter tablespace <Tablespace_where_data_is_going_to_be_imported> nologging;'

prior to the import operation.
This may work.

Hope it helps,
Regards,
seethem

Report message to a moderator