Hi Everyone:
I am using the latest version of Oracle Navicat Enterprise edition.
While I consider Navicat my favorite Oracle IDE, I am very disatisfied with its ability to dump/import data.
When I right click on a schema and select the dump option, it doesn't export important data such as names give to primary/foreign/constraints (instead it doesn't list the names and when an import is done everything is give one of oracles names like: sys23322322. Several times I have lost a lot of work this way.
The other thing it does not do properly is export views properly when dumping. If the views are very simple and don't use aliases it works ok. Where I work some of the views can be very large and include a lot of aliases. when a dump is done with Navicat, the aliases are never exported and the views as a result are often broken.
Am I missing some setting that will allow me to export these kinds of data or do I have to keep using SQL Developer to export schemas?
Matthew
I am using the latest version of Oracle Navicat Enterprise edition.
While I consider Navicat my favorite Oracle IDE, I am very disatisfied with its ability to dump/import data.
When I right click on a schema and select the dump option, it doesn't export important data such as names give to primary/foreign/constraints (instead it doesn't list the names and when an import is done everything is give one of oracles names like: sys23322322. Several times I have lost a lot of work this way.
The other thing it does not do properly is export views properly when dumping. If the views are very simple and don't use aliases it works ok. Where I work some of the views can be very large and include a lot of aliases. when a dump is done with Navicat, the aliases are never exported and the views as a result are often broken.
Am I missing some setting that will allow me to export these kinds of data or do I have to keep using SQL Developer to export schemas?
Matthew
Comment