Home » RDBMS Server » Server Utilities » Incremental/Patial database export and import
Incremental/Patial database export and import [message #365460] Mon, 22 June 1998 08:06 Go to next message
Banda
Messages: 1
Registered: June 1998
Junior Member
Soul on fire, pliz help.

I need to to full export and import. This takes 4 days.
I can afford two only. Is there way of doing partial export/import? Incremental export/import?

Report message to a moderator

Re: Incremental/Patial database export and import [message #365462 is a reply to message #365460] Mon, 22 June 1998 11:51 Go to previous message
Sarvesh
Messages: 7
Registered: June 1998
Junior Member
Well, If you do export/import with indexes and constraints it will take its own time to complete the task. Try exporting TABLES only, or export all objects and import just TABLES only put INDEX=N and CONSTRAINTS=N in your import script. You can re-construct indexes and constraints using your scripts. Have a bigger rollback segments if you want to do import with COMIT=N.

Report message to a moderator

Next Topic: Import/Export & disabling constraints
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 02 22:33:57 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.