Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Wink Unanswered: Exporting/Importing CLOB tables

    I am trying to export a table from one oracle database and import it into another. The table contains clob information and its tablespace exists under a different name in the destination database.

    The exp command works fine to export the table, but when using imp to import the table a warning is given that the origin table owner is different to the destination, although it then seems to translate the data and says that it imported OK. No data is imported however.

    Can anyone help me resolve this issue?

    Thanks.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    In the import.par file specify
    fromuser=xxx
    touser=xxy
    Rgs,
    Breen.

Posting Permissions

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