Home » RDBMS Server » Server Utilities » Export Error. (11g)
icon7.gif  Export Error. [message #467586] Mon, 26 July 2010 02:59 Go to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear DBA's Experts,

When we are trying to Export one table using below command

C:\Oracle\Middleware\as_1\bin\exp.exe userid=system/eclipse@webnis  file=D:\nisadmin26Jul2010.dmp  log=D:\exp2.log  
owner=nisadmin tables=sales_salesman


We received this error.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing option
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully



Kindly advise me.

Regards,

Irfan

[Updated on: Mon, 26 July 2010 03:20] by Moderator

Report message to a moderator

Re: Export Error. [message #467590 is a reply to message #467586] Mon, 26 July 2010 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot specify "owner" and "tables" parameter at the same time.

Regards
Michel
Re: Export Error. [message #467595 is a reply to message #467590] Mon, 26 July 2010 03:18 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear Mr.Michel,

Thank you very much for prompt reply.

After removing owner parameter.

C:\Oracle\Middleware\as_1\bin\exp.exe userid=nisadmin/n1sadm1n@webnis  
file=D:\nisadmin26Jul2010.dmp  log=D:\exp2.log  tables=sales_salesman 


We have this table NISADMIN.SALES_SALESMAN in our database pls see below log file.



Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing option
Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
EXP-00011: NISADMIN.SALES_SALESMAN does not exist
Export terminated successfully with warnings.




Regards,

Irfan


[Updated on: Mon, 26 July 2010 03:20] by Moderator

Report message to a moderator

Re: Export Error. [message #467596 is a reply to message #467595] Mon, 26 July 2010 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I tend to trust Oracle.
Either you have not this table, either you don't reach the database you think you're going to.

So execute:
sqlplus nisadmin/n1sadm1n@webnis  
select table_name from user_tables where table_name = 'SALES_SALESMAN';

Regards
Michel
Re: Export Error. [message #467603 is a reply to message #467596] Mon, 26 July 2010 03:44 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:


I tend to trust Oracle.
Either you have not this table, either you don't reach the database you think you're going to.

So execute:

Code: [Select all] [Show/ hide]sqlplus nisadmin/n1sadm1n@webnis
select table_name from user_tables where table_name = 'SALES_SALESMAN';

Regards
Michel





Please see.

./fa/8079/0/


Regards,

Irfan
  • Attachment: Exp.JPG
    (Size: 50.21KB, Downloaded 956 times)
Re: Export Error. [message #467606 is a reply to message #467603] Mon, 26 July 2010 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you are not in the same ORACLE_HOME for both commands, I think you are not reaching the database you think you reach.
One ORACLE_HOME is 11.2 and the other one is 11.1, verify consistency in tnsnames.ora from both homes.

Regards
Michel
Re: Export Error. [message #467608 is a reply to message #467606] Mon, 26 July 2010 03:58 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Mr.Michel,

Yes, you are right.let me check and then I'll told you.

Quote:
One ORACLE_HOME is 11.2 and the other one is 11.1.



Thanks & regards,

Irfan
icon8.gif  Re: Export Error. [message #467649 is a reply to message #467608] Mon, 26 July 2010 07:30 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear Michel,

I am unable to solve my problem.
Kindly see this.


./fa/8082/0/




Please advise me.

Regards,

Irfan
  • Attachment: export.JPG
    (Size: 73.44KB, Downloaded 867 times)
Re: Export Error. [message #467657 is a reply to message #467649] Mon, 26 July 2010 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, it rests one option: open a SR to Oracle.

But before, a last check, put the result of:
set


Regards
Michel

[Updated on: Mon, 26 July 2010 07:55]

Report message to a moderator

Re: Export Error. [message #467786 is a reply to message #467657] Tue, 27 July 2010 05:55 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:


In this case, it rests one option: open a SR to Oracle.

But before, a last check, put the result of:

 set 


Regards
Michel



I can't understand it.


Kindly explain it again.

Regards,

Irfan
Re: Export Error. [message #467788 is a reply to message #467786] Tue, 27 July 2010 06:03 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
At the command prompt, type SET and press <Enter>. Post the result. (That would be the last check).

Go to Oracle support and open a Service Request (i.e. explain what is bothering you, and people form Oracle Support will help you solve the problem). (That would be the one option).

Re: Export Error. [message #467852 is a reply to message #467786] Tue, 27 July 2010 13:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is the table empty?
May be due to deferred segment creation.
Re: Export Error. [message #467853 is a reply to message #467786] Tue, 27 July 2010 14:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> show parameter deferred

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation            boolean     TRUE

SQL> create table t5 (c1 integer);

Table created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

oracle@eddie#exp scott/tiger tables=t5

Export: Release 11.2.0.1.0 - Production on Tue Jul 27 14:59:36 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
EXP-00011: SCOTT.T5 does not exist
Export terminated successfully with warnings.

oracle@eddie#sqlplus -s scott/tiger <<EOF
> insert into t5 values (1);    
> exit;
> EOF

1 row created.

oracle@eddie#exp scott/tiger tables=t5

Export: Release 11.2.0.1.0 - Production on Tue Jul 27 15:01:16 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                             T5          1 rows exported
Export terminated successfully without warnings.
Re: Export Error. [message #467887 is a reply to message #467852] Wed, 28 July 2010 01:28 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear Mahesh ,

Thank you very much for reply.

Quote:

Mahesh Rajendran

Is the table empty?
May be due to deferred segment creation.



Yes,you are right these tables are empty.

Regards,

Irfan


Re: Export Error. [message #467896 is a reply to message #467887] Wed, 28 July 2010 03:14 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear Mahesh thankx ,

My Problem solved After Inserting data in these table.


Re: Export Error. [message #467916 is a reply to message #467896] Wed, 28 July 2010 04:51 Go to previous messageGo to next message
John Watson
Messages: 4515
Registered: January 2010
Location: Global Village
Senior Member
@Mahesh
Nice one! This is an interesting addition to the first topic I raised on Orafaq, earlier this year:
http://www.orafaq.com/forum/mv/msg/154204/440027/0/#msg_440027
The effect on exp is surprising, clearly exp does more than just a select on the table, it must require the segment as well. I'll have to do some more reverse engineering....
Re: Export Error. [message #468010 is a reply to message #467916] Wed, 28 July 2010 09:56 Go to previous message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I just stumbled upon it while researching for this post on sequences.
http://www.orafaq.com/forum/t/160048/42800/
As posted, first I was not able to reproduce the case while everyone were able to!.
The database I used for testing is been upgraded from 10gR1 to 11gR2 (my sandbox)
and had compatible value set to 10.2.0.1! My bad.
After tinkering a lot, I was able to confirm the issue was with deferred segment creation , spent some time on it and came across the issue with Exports.
EBrian solved the puzzle before I can produce a proof.
Previous Topic: CONCATENATE A DATE WITH SQL LOADER FROM THREE FIELDS
Next Topic: SQL-Loader: How to dynamically create multiple records out of one CSV input line?
Goto Forum:
  


Current Time: Fri Aug 29 19:25:55 CDT 2014

Total time taken to generate the page: 0.10023 seconds