How to export / backup a schema remotely?
659873Sep 29 2008 — edited Oct 1 2008Hi,
On the project I am working on, I have DBA role on the schema (we own the data & schema). But I have no access to the server as it is maintained by a 3rd party company.
Is it possible to make a backup of a schema so that I can restore it on my laptop for testing deployment scripts which will do a lot of DDL. I have try SQL Developer 1.51.5440 (Menu Tools, Database Export or Database Copy). It completes the task partially some tables are missing because of FK violation, table/view not found. May be SQL Developer process table by alphabetical order. If table A reference table Z, then as A is created first, it will fail the FK constraint.
In anyway, so far I don't have 100% confidence on SQL Developer feature for Exporting/Copying a DB. May be I didn;t do the setting properly, if there is any solution, I would appreaciate.
Then I tried TOAD 9.7, using Menu Database, Export, Export Utility Wizard) : got error
EXP-00056:
ORACLE error 6401 encountered
ORA-06401: NETCMN: invalid driver designator
EXP-00000: Export terminated unsuccessfully
I have no clue what that meant. May be there is a solution. I hope I don't violate the forum rules by talking about Toad. If so please excuse me in advance.
My question is simple: providing I have DBA role, how can I do a dump, backup, export (don't know what is the proper Oracle vocabulary to call an entire backup of a schema + data) of a schema without having physical access to the database server?
Thank you very much in advance for any help.