import only data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: import only data

  1. #1
    Join Date
    Jan 2001
    Posts
    216

    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?

  2. #2
    Join Date
    Jan 2001
    Posts
    216
    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
  •  



Click Here to Expand Forum to Full Width