Home » RDBMS Server » Server Utilities » Import undo (How make that import don't create undo?)
Import undo [message #275710] Mon, 22 October 2007 08:22 Go to next message
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
Re: Import undo [message #275713 is a reply to message #275710] Mon, 22 October 2007 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No way.

Regards
Michel
Re: Import undo [message #275714 is a reply to message #275713] Mon, 22 October 2007 08:38 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
And rman does generate undo?
Re: Import undo [message #275719 is a reply to message #275714] Mon, 22 October 2007 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.

Regards
Michel
Re: Import undo [message #278492 is a reply to message #275710] Sun, 04 November 2007 13:59 Go to previous messageGo to next message
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
Re: Import undo [message #278497 is a reply to message #278492] Sun, 04 November 2007 14:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ nologging is for redo and not undo
2/ nologging is for direct operations and import is not a direct operation

Regards
Michel
Re: Import undo [message #278505 is a reply to message #275710] Sun, 04 November 2007 14:50 Go to previous message
seethem
Messages: 41
Registered: September 2007
Member
yip good point there Michael.
Previous Topic: Using Client side "exp"
Next Topic: expdp error
Goto Forum:
  


Current Time: Tue Dec 24 23:59:24 CST 2024