1 Reply Latest reply: Dec 1, 2013 11:48 PM by Anar Godjaev RSS

    Export and import structure

    45cb6f2f-52bb-4f38-95f8-d64f35257de7

      Hi,

       

      I am trying to export and import structure of the tables. But when i import the dump file, i think i am not able to import constraints properly. Because primary and foreign key is not displaying when i enter

      'DESC TABLENAME'.

      only column name is displaying not the constraint.

       

      Export and import Query:

       

      exp user/pwd file=c:\sco.dmp log=sco.log

      imp user/pwd file=c:\sco.dmp rows=n

       

      Please correct me.

       

      Regards,

      Priya