Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> exp / imp
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 14 2001 - 20:29:53 CDT