Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: exporting data subset

    Hi,

    I want to export a subset of a table and any information (from other tables)that is referenced in the first table.

    Imagine that I have a table named BOOK and another named AUTHOR.
    A colunm in BOOK references the author, which is in the table AUTHOR.

    I want to export a subset of books, and the authors of these books.

    Is it possible to do it using the "exp" command?

    Thans in advance,

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    In Oracle 10g (I'm not sure about 9i, but am quite certain that earlier versions don't support this option) you can use QUERY parameter in export command line mode. Check it here.

  3. #3
    Join Date
    May 2006
    Posts
    132
    As a work-around, you may want to consider creating a materialized view of your query criteria and then export just the materialized view table.

Posting Permissions

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