OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export Error. (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Error. [message #467586]

Mon, 26 July 2010 02:59

ranamirfan
Messages: 535
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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You cannot specify "owner" and "tables" parameter at the same time.

Regards
Michel

Report message to a moderator

Re: Export Error. [message #467595 is a reply to message #467590]

Mon, 26 July 2010 03:18

ranamirfan
Messages: 535
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

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Export Error. [message #467603 is a reply to message #467596]

Mon, 26 July 2010 03:44

ranamirfan
Messages: 535
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.

/forum/fa/8079/0/

Regards,

Irfan

Attachment: Exp.JPG
(Size: 50.21KB, Downloaded 2692 times)

Report message to a moderator

Re: Export Error. [message #467606 is a reply to message #467603]

Mon, 26 July 2010 03:50

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Export Error. [message #467608 is a reply to message #467606]

Mon, 26 July 2010 03:58

ranamirfan
Messages: 535
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

Report message to a moderator

Re: Export Error. [message #467649 is a reply to message #467608]

Mon, 26 July 2010 07:30

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Michel,

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

/forum/fa/8082/0/

Please advise me.

Regards,

Irfan

Attachment: export.JPG
(Size: 73.44KB, Downloaded 2444 times)

Report message to a moderator

Re: Export Error. [message #467657 is a reply to message #467649]

Mon, 26 July 2010 07:52

Michel Cadot
Messages: 68641
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

ranamirfan
Messages: 535
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

Report message to a moderator

Re: Export Error. [message #467788 is a reply to message #467786]

Tue, 27 July 2010 06:03

Littlefoot
Messages: 21807
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).

Report message to a moderator

Re: Export Error. [message #467852 is a reply to message #467786]

Tue, 27 July 2010 13:52

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

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

Report message to a moderator

Re: Export Error. [message #467853 is a reply to message #467786]

Tue, 27 July 2010 14:02

Mahesh Rajendran
Messages: 10707
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

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

About to export specified tables via Conventional Path ...
. . exporting table T5 1 rows exported
Export terminated successfully without warnings.

Report message to a moderator

Re: Export Error. [message #467887 is a reply to message #467852]

Wed, 28 July 2010 01:28

ranamirfan
Messages: 535
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

Report message to a moderator

Re: Export Error. [message #467896 is a reply to message #467887]

Wed, 28 July 2010 03:14

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Mahesh thankx ,

My Problem solved After Inserting data in these table.

Report message to a moderator

Re: Export Error. [message #467916 is a reply to message #467896]

Wed, 28 July 2010 04:51

John Watson
Messages: 8929
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....

Report message to a moderator

Re: Export Error. [message #468010 is a reply to message #467916]

Wed, 28 July 2010 09:56

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 02:52:06 CDT 2024