Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Simple Export Question
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
![]() |
![]() |