OraFAQ Forum: Server Utilities » EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i

Home » RDBMS Server » Server Utilities » EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i (Developer Suite Form 10g, Oracle Database 11g, Windows2003 Server)

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

EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388780]

Thu, 26 February 2009 03:38

m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

Member

Hi,

I used to use:

 HOST('exp '||USR||'/'||PWD||'@'||CNSTR||' owner=xdata     grants=y file='||LTRIM(RTRIM(:drive))||
'\OraData\Exp\X'||dt_time||'xdata.dmp     log='||LTRIM(RTRIM(:drive))||'\OraData\Exp\X'||dt_time||'xdata.log') ;

for Database Backup in Oracle 8i that worked fine. But, the same command is not functioning in Oracle 11g. Can anybody please tell me why?

Regards-

Mohd. Golam Hossain

[Updated on: Thu, 26 February 2009 05:27] by Moderator

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388793 is a reply to message #388780]

Thu, 26 February 2009 04:18

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Don't report you own messages to get attention.

Also "IS NOT WORKING" is not an Oracle error message.

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388796 is a reply to message #388793]

Thu, 26 February 2009 04:25

m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

Member

Ok, I'll not again.

I meant by IS NOT WORKING that no data is exported into the dmp file, log file also empty.

Thank you for your kind attention.

Regards.

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388798 is a reply to message #388780]

Thu, 26 February 2009 04:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And export is NOT a backup tool.

Regards
Michel

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388803 is a reply to message #388798]

Thu, 26 February 2009 04:37

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

So step one would be to just output the command in the script, not execute it.

Then run the command by itself, and see what errors it runs into.

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388812 is a reply to message #388803]

Thu, 26 February 2009 05:16

m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

Member

Yes, I have tried this. But for no use.

Would you please see the attached files.

Regards.

Attachment: TEMP.JPG
(Size: 33.09KB, Downloaded 1305 times)

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388816 is a reply to message #388812]

Thu, 26 February 2009 05:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't post a screen copy, cope and paste it in text format.

Regards
Michel

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388819 is a reply to message #388816]

Thu, 26 February 2009 05:29

m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

Member

Thank you for your attention.


D:\>exp bizac/XYZ@GDNMTD owner=BizAc grants=y file=C:\TEMP\TEMP.DMP log=C:\TEMP\TEMP.LOG

Export: Release 9.0.1.5.1 - Production on Thu Feb 26 17:03:46 2009

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
D:\>

regards.

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388820 is a reply to message #388819]

Thu, 26 February 2009 05:30

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I doubt that a 9.0 client can connect a 11g server.

Regards
Michel

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388823 is a reply to message #388820]

Thu, 26 February 2009 05:35

m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

Member

Yes.

Export: Release 9.0.1.5.1 did not connect to oracle 11g.

But,
Export: Release 11.1.0.6.0 worked fine.

Thank you with best regards.

[Updated on: Thu, 26 February 2009 05:53]

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388864 is a reply to message #388823]

Thu, 26 February 2009 07:50

shekharnegi12
Messages: 52
Registered: October 2008

Member

Morning Fellas,

Correct me if I'm wrong but don't he need to use the expdp utility for exporting the data.

Thanks,
Shekhar

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #388875 is a reply to message #388864]

Thu, 26 February 2009 08:09

m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

Member

It is Ok to use advanced EXPDP. I needed EXP for backward compatibility.

Thanks.

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #475122 is a reply to message #388780]

Mon, 13 September 2010 02:47

cleany
Messages: 2
Registered: September 2010
Location: Netherlands

Junior Member

I know this is old, but I've got the same problem.

Is there a structural solution for this?

[Updated on: Mon, 13 September 2010 02:47]

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #475126 is a reply to message #475122]

Mon, 13 September 2010 04:00

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Yes, all solutions to the problems in this thread are already mentionend in this thread. Have you tried them?

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #475128 is a reply to message #475126]

Mon, 13 September 2010 04:03

cleany
Messages: 2
Registered: September 2010
Location: Netherlands

Junior Member

no, because they're not actual solutions to my problem.

I have a 11g database, the customer has a 9i database, so I have to export my 11g database to 9i. I've got a client to do so, but it halts after the message that my export is done and blah blah without any (error) message.

Report message to a moderator

Re: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i [message #475133 is a reply to message #475128]

Mon, 13 September 2010 04:33

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Ah, so you have a completely different problem that was never actually mentioned in this thread.

A 9.2.0.8 export client (The LATEST patchset of release 9.2) might work against a 11g database, but only if the 11g database doesn't use any datatypes or other constructs that are not supported by 9i.

Does the ORACLE_HOME of your export client have the latest patchset? Does the 11i instance use any constructs that are not supported by Version 9?

Report message to a moderator

Previous Topic:	Trim date characters within sql loader
Next Topic:	sqlldr caused error with 00h symbol in source file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 21:38:51 CST 2024