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
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.
Can you please past database version..
SQL> select * from v$version;