General Question

onemorego's avatar

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Asked by onemorego (2points) July 30th, 2009

Using sqlplus to connect to a database using tnsnames. I just want to dump the entire contents to a local file without doing something like connecting and spooling.

Observing members: 0 Composing members: 0

2 Answers

hex's avatar

By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

hex (464points)“Great Answer” (0points) Flag as…
GrimMeeper's avatar

I think exp is your best option. It is possible to use a SQL script to generate create table statements and then also insert statements, but this a horrendously long winded way to get this done.

GrimMeeper (52points)“Great Answer” (0points) Flag as…

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther