-
import only data
We are in the process of adding delete cascade to all our tables. The easiest way to propagate this change to customers, I thought was to export the data, create the new schema with the cascade delete on (no other schema changes) and then import back only the data. Would this work? If so, whats the parameter in the imp command to import only data?
-
Never mind, just read on the oracle documentation for import that we have to disable all constraints before doing import onto existing tables... so, that will be a pain anyway.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|