I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files or ssh to it. Also, I can't shutdown the database. What I'm trying to achieve is to get a test db from our production db without interfering with db operations. I dont need all the data to be up to date in test environment.
Seems all the usual file backups and RMAN require either direct access to files or require me to shutdown the database. Expdp also dumps the files to the server, not to the client. Is there any other method than to dump db with expdp directly to other server? The other server is on a remote location so that would probably take too long…
Thanks
Best Answer
You can use the
EXPtools out of another oracle setup or a full client install. Make sure to use theCONSISTENT=Yflag and do not run the export during a business-critical time. A good primer on EXP/IMP available here.@Derfk points out a way to do network export/import using the datapump tools, documented in the Network Import section of this page. Note you will need to create a database link between production and development to copy across, but won't need to create the intermediate file. Full disclosure: I haven't ever done that particular thing.