| EXP-00026: conflicting modes specified [message #19224] |
Tue, 05 March 2002 22:06  |
krahuman
Messages: 18
Registered: January 2002
|
Junior Member |
|
|
Hello ORA8is !
why i can't get a backup from the following ?
host('exp scott/tiger@oracle
file=c:backupcustomer.dmp
log =c:backupcustomer.log
owner=scott grants=y rows=y tables = customer');
when i execute this in d2k forms 5.0 IN THE ora.server only a zero bytes customer.dmp
is created.
the follwing is the log genarated.
Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully
if i want to run this in a cliect what are the utilities i have to install to the client?
krahuman
|
|
|
|
| Re: EXP-00026: conflicting modes specified [message #19228 is a reply to message #19224] |
Wed, 06 March 2002 04:24  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
the error is EXP-00026, which says
" only one parameter (TABLES, OWNER, or FULL) can be specified"
u have specifed tables as well as owner.
it seems u r only want to export customer table , os take out "owner=scott", this is not required as u r connecting as "scott" user
so ur final command should be
host('exp scott/tiger@oracle
file=c:backupcustomer.dmp
log =c:backupcustomer.log
grants=y rows=y tables = customer');
i think this will solve ur problem
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
