0

I use PLSQL Developer 10.0.2 (the latest registered version) to export Oracle 11g tables. After I import these tables, I found all the tables lost reference key. I don't want to use SQL Plus.

How can I fix this issue?

Simon Adcock
  • 3,554
  • 3
  • 25
  • 41
Deep in Development
  • 497
  • 2
  • 8
  • 24
  • See this SO question: http://stackoverflow.com/questions/10886450/how-to-generate-entire-ddl-of-an-oracle-schema. Also read more about DBMS_METADATA package on Oracle Docs. That should solve your problem. – Rachcha Apr 22 '13 at 18:39
  • in the `imp`/`exp` there is a parameter called `CONSTRAINTS`. check if when you use plsql developer there is a check box for that. if it still not working - do it manually from the cmd. – haki Apr 22 '13 at 19:03

1 Answers1

0

Actually it is an Pl/Sql Developer internal bug. It has been fixed by Allround Automations company in their latest Pl/Sql Developer 10.0.5.1710.

Deep in Development
  • 497
  • 2
  • 8
  • 24