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

Thread: import only data

  1. 11-13-2002, 05:57 PM #1
    chikkodi
    chikkodi is offline Member
    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?
    Reply With Quote Reply With Quote
  2. 11-13-2002, 06:06 PM #2
    chikkodi
    chikkodi is offline Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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