CODEWITHSUNDEEP
databaseoracle-database
Alan Han
Alan Han

Reputation: 960

Oracle database: Export schema to another machine

I have a oracle database installed on a server, I want to export one schema to a dump file but this server does not have enough hard drive space. Can I use expdp to export to another machine?

Thank you!

Upvotes: 0

Views: 1189

Answers (1)

Alex Poole
Alex Poole

Reputation: 191560

If you can mount a volume from the second machine then you can export 'locally'. How you do that depends on your operating system etc.

If the second machine already has an Oracle instance you could use its expdp with the network_link parameter. This will export from the first machine rather than to the second machine, but if the software is available then the end result should be the same and it's just semantics...

Upvotes: 1

Related Questions