export-import on tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export-import on tables

  1. #1
    Join Date
    Dec 2000
    Posts
    138

    Question

    Hi,
    I have to export all the tables using the export's "where clause" in 8i, the caveat is that the tables i export and import should be in the correct hierarchy (or dependency) , and to my knowledge its not possible to get the hierachy of the tables in 8i (8.1.6.3), has anyone faced this problem and solved it, are there anyother ways to do it.and for ur info we have RLS on the schema too.
    I thought of using "copy from db to db" but again the table hierarchy is nagging.

    I'd appreciate any help or tips.
    Thanks,
    Dharma.

  2. #2
    Join Date
    Oct 2001
    Posts
    122
    If you are using a single dump for all involved tables Oracle will take care of dependency internally (if all related data are there).

    Alternatively you can use Defferable Constraints feature.

    i.e. First just create table structure in Traget schema with Defferable Constraints feature with initially deffered clause
    for all FK constraints.

    Second import the data from your export ignoring all creation errors.

    Hope this helps.

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