Export remote Database : Oracle

Question

I have an oracle database on a server that contains more than one database, i'm connected to those databases using sqlDevelopper normaly. I want to export the database DB1. The string connection used in SqlDevelopper is :

user@//server:1530/DB1
user@//server:1533/DB2
user@//server:1534/DB3

The command i use to export the DB1 is :

exp user@//server:1530/DB1 file="C:\DB1.dmp" log="C:\DB1.log" rows=y owner=user

But it doesn't work, i have this message :

EXP-00056: Erreur ORACLE 6401 rencontré
ORA-06401: NETCMN : désignation de lecteur non valide
EXP-00000: Procédure d'export terminée avec erreur

How can I adjust the exp command to have the desired result?

What database and exp versions are you using? The 10g and 11g versions of exp seem to recognise that 'easy connect' syntax, but the 9i version doesn't. (If you are on a later version than 9i, you should probably be using expdp in preference to exp anyway). If you are using 9i exp and can't use a later version then you probably need to use a TNS alias, defined in your tnsnames.ora. — Alex Poole
– Alex Poole, Commented Oct 23, 2012 at 17:02
I've created an alis on my tnsnames BD1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server) (PORT = 1530) ) ) (CONNECT_DATA = (SERVICE_NAME = DB1) ) ) How can i use it now? — Potinos
– Potinos, Commented Oct 23, 2012 at 17:14
Be aware that exporting data remotely will be much slower than exporting locally and transferring over network. — ali köksal
– ali köksal, Commented Oct 23, 2012 at 18:34

Alex Poole · Accepted Answer · 2012-10-23 17:23:32Z

7

Following on from comments suggesting you're using a pre-10g version that doesn't support the easy connect syntax, and therefore also can't use data pump...

If you've created a tnsnames.ora entry like:

BD1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP) (HOST = server) (PORT = 1530))
    )
    (CONNECT_DATA = (SERVICE_NAME = DB1))
  )

... then you should be able to export using:

exp user@BD1 file="C:\DB1.dmp" log="C:\DB1.log" rows=y owner=user

(where BD1 is the alias name; not sure if you intended to spell it like that, but you could use DB1 if you preferred).

answered Oct 23, 2012 at 17:23

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Potinos Over a year ago

That is exactely what i did but still have another error : EXP-00056: ORACLE error 12541 encountered ORA-12541: TNS:no listener EXP-00000: Export terminated unsuccessfully

Alex Poole Over a year ago

@Potinos - that suggests the server or 1530 are wrong, since there doesn't seem to be a listener at server:1530. Possibly a typo, or the data you have for the SQL Developer connection is out of date, or maybe something odd is happening with name resolution. Or you already had an entry in a tnsnames.ora and you aren't using the one you think. Try tnsping BD1 and check what that says it's connecting to.

Potinos Over a year ago

I supposed that too, but i'm connected to server at 1530 with sqlDevelopper and no matter!

Collectives™ on Stack Overflow

Export remote Database : Oracle

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related