Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1727
  • Last Modified:

Export selected tables?

I am using Oracle 8, with exp80 and trying to export only a few selected
tables. From the Windows XP or Windows NT Dos prompt
I use exp80 Userid=user/pass then with asks Tables I put a t
and it begins asking for tables names and this works fine.
I then tried to run by a batch job with the following.
exp80 sysytem/mang fromuser=user touser=user file=c:\select.dmp tables=(
table1, table2, table3) log=c:\select.log full=n buffer=4096.
I get ORA-06402 error NETCMN invalid driver designated.
What could I be doing wrong?
0
thom_lsb
Asked:
thom_lsb
  • 5
  • 5
1 Solution
 
bkowalskiCommented:
This is the explanation for that error message:

Error:  ORA 6402  Text:   NETCMN:  error receiving break message  Cause:  The SQL*Net driver detected that its server has unexpectedly exited. Action: Check the network operating system and resubmit the connect string.

But there is a problem with your export.  You do not use fromuser or touser in an export, take those out and it should run o.k.
0
 
thom_lsbAuthor Commented:
What do you mean by server has unexpectedly excite.
What should I use instead of fromuser & touser?
Thanks for your response.
0
 
bkowalskiCommented:
The error message indicates that possibly your server was not available. Are you sure the server was up when you ran the batch job? Does it run at night, did you test it during the day?

You don't use anything instead of fromuser, touser, take them out of your command line statement:

exp80 system/manager file=c:\select.dmp tables=(table1,
table2, table3) log=c:\select.log full=n buffer=4096
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
thom_lsbAuthor Commented:
Yes the server is available, I did export form DOS command
and it worked but batch won't.
You mean i don't need a user name and password?
Thanks again for your response..
0
 
bkowalskiCommented:
The username and password is system/manager in this scenario, those are still there.  The fromuser and touser parameters are for import, not export, so I've taken them out.

This is what I would do. Put all parameters in a paramter file, for example select.par, which would look like this:

buffer=4096
file=c:\select.dmp
full=n
log=c:\select.log
tables=(table1, table2, table3)
userid=system/manager

And then your command line would be simple:

exp80 parfile=select.par
or
exp80 parfile=c:\select.par

or whatever the path might be.
0
 
bkowalskiCommented:
If batch still won't work, try using the connect string in your user parm:

userid=system/manager@testdb

where testdb is a connect string in your tnsnames file.
0
 
thom_lsbAuthor Commented:
Niether of these work.
I'm open to anything.
Thanks,
0
 
DanielztCommented:
try this:

 exp80 user/pass@service_name file=table_dump.dmp tables=table_a,table_b,...  log=table_dump.log

you need to find service name from your tnsnames.ora.




0
 
thom_lsbAuthor Commented:
This worked at the DOS command line and I also
made a batch file with that in it and it worked.
0
 
thom_lsbAuthor Commented:
It worked at DOS command line and I made
a batch file and it also worked.
Thanks for your quick respones and excellent suggestions.
Ed
0
 
bkowalskiCommented:
Didn't I say to use a connect string in my post 03/19/2003 12:12PM PST???
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now