we're running a RDS machine (thats the Amazon Web Services type of a database) with Oracle 22.214.171.124.5 on it. At Amazon Web Services machines we didn't have access to te file system of the database, so no remote connection is available.
Now i try to find a way and a tool with that I'm able to export a complete schema with it's objects and data sets to an SQL file. Did you guys know any tool for that?
I'm searching in SQL Developer but i didn't find the way...
Thanks and regards,
:-) - not that kind of export - sqldeveloper export - this creates a file on the client. A sql file with create table and a load of insert statements - the first thing it gets you to do uis select a file (on the client) where the output should be sent to! go to the tools - database export menu and you'll see.
there are probably other tools on the market that can do this - we use plsql developer and thats seems much like sqldeveloper and doesn;t do what you want.
Another alternative (if you have an oracle db locally at your site) is to use datapump using a network_link to create a local file on your machine from the remote machine - i blogged about that here:
can you create a db link to AWS and do this?