Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Simple Export Question

Simple Export Question

From: Sheerfun <maheshswam_at_earthlink.net>
Date: 2000/06/01
Message-ID: <DUhZ4.6055$MY6.139184@newsread2.prod.itd.earthlink.net>#1/1

I want to export the tables and sequences and views for a user from one database and then import it in to another database where the tables already exist with constraints and references.
* exp userid/passwd_at_sid owner=user rows=yes

I want to know if the dependencies would be automatically resolved. That is, would it find the foreign key references and load the nested tables and then load the tables. Or do i have to disable all the constraints before import and again enable them? Or is there a special parameter that i can specify for that?

Thank you in advance. Received on Thu Jun 01 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US