| Import/Export & disabling constraints [message #365463] |
Mon, 22 June 1998 14:59  |
Jana Reeves Badham
Messages: 6
Registered: June 1998
|
Junior Member |
|
|
Prior to doing a table export I disable all constraints
associated with the table. When I tried to drop
the table prior to importing I recieved the error
"Drop Table Failed Because of unique/foreign key".
How would I get around this problem??
|
|
|
|
|
|
| Re: Import/Export & disabling constraints [message #365466 is a reply to message #365463] |
Tue, 23 June 1998 12:26  |
Tom
Messages: 67
Registered: June 1998
|
Member |
|
|
It sounds like you know how to list the constraints by type/owner/table. I will assume that you are trying to reduce the number of extents in some tables. No other schema's refer to the tables that you are going to rebuild.
1. Know how to recreate the user you are going to drop. List the defaults including security and tablespaces.
2. Do a full database export.
3. Drop and recreate the user.
4. add data files.
5. import user. might take 2 passes.
This will re-build all the triggers / precedures / constraints / packages. rel 7.3.3
Check out export/import in the dba handbook for parms. I was told that there is a disable all user constraint command. but I haven't used it.
I try to time this kind of work just after a backup. just incase.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
