Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186

    Question Unanswered: Can I import specific rows from a dump file

    Hi,

    I have a dump file (Oracle 9.2.0.1) with one table in and I only want to import a few hundred rows (the dump file is a couple of gig and will take a long time to process) can I specify a where clause (I think you can for an exp) but I can't see anything in the documentation for imp so I guess not, but if anyone knows differently ....

    cheers
    Robert
    There are 10 types of people in the world, those that know Binary and those that don't.

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    I've got around it by creating a constraint on the table so the records I don't want will fail in the import and that seems to be working
    There are 10 types of people in the world, those that know Binary and those that don't.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •