Re: exp / imp

Might also be a good idea to disable any insert / update triggers on the table!

D.P.

Steve wrote:
>
> You can import into a table that already exists.
> You only need to disable your constraints if they are going to be broken
> during the load, so it is a good idea to disable them.
>
> You might care to read the manual.... it is now on-line on the Oracle
> website http://otn.oracle.com/docs/index.htm, you will need to register at
> no cost. I have found the on-line documentation very useful. It prevents me
> from referring back to my old manuals (a version out of date, but still
> quite useful) or running around the client's office trying to locate their
> manuals.
>
> ----------
>
> You can specify ignore=y in command line param so that you need not drop the
> table. But you must ensure the table existing is empty, or duplicate records
> may exists.
> index, foreign key constraints are imported as the table import, you can
> specify indexes=n to suppress the indexes to be imported. So the command
> line maybe:
>
> imp userid=.../...@... tables=... indexes=n ignore=y
>
> -----------
>
> You could export the table.
>
> disable constraints
>
> Truncate table
>
> Import table
>
> Reenable constraints.
>
> Or
>
> Export table
>
> Drop table cascade constraints
>
> Redefine everything including grants
>
> Reimport everything.
>
> alter table xxx move in 8i works pretty good if not IOT.
Received on Sat Apr 21 2001 - 21:38:07 CDT