OraFAQ Forum: Windows » trasportable tablespace error during export

Home » Infrastructure » Windows » trasportable tablespace error during export (oracle 8i)

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

trasportable tablespace error during export [message #621990]

Wed, 20 August 2014 05:45

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

I want to take backup of database ,i have to make dump file
but when i try to run export command i get following error.
I tried following command also bt getting same error

exp user/password@sid file=path:\filename.dmp full=y rows=y grants=y;

I have no idea about transportable tablespace.
Please help me how to resolve this.
Thanks

Attachment: tts.JPG
(Size: 81.50KB, Downloaded 2942 times)

[Updated on: Wed, 20 August 2014 05:48]

Report message to a moderator

Re: trasportable tablespace error during export [message #621992 is a reply to message #621990]

Wed, 20 August 2014 05:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's no error. You didn't do anything, as the only command you issued was "EXP". It displayed a short help screen, which shows options you can use with the EXP command.

Do you really (still) use Oracle 8i? Here's documentation, read it.

Report message to a moderator

Re: trasportable tablespace error during export [message #621995 is a reply to message #621990]

Wed, 20 August 2014 05:58

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

Senior Member
Account Moderator

Quote:

I want to take backup of database

You do NOT backup a database with an export.

Quote:

I have no idea about transportable tablespace.

What is the relation with this and what you want to do ("take backup of database")?

Report message to a moderator

Re: trasportable tablespace error during export [message #622004 is a reply to message #621992]

Wed, 20 August 2014 07:15

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

Quote:

There's no error. You didn't do anything, as the only command you issued was "EXP". It displayed a short help screen, which shows options you can use with the EXP command.

i have mentioned in my my post that i used following code also but i am getting the same error and if i run 'EXP' cmd only then that should also work after that it asks for username and password.

exp user/password@sid file=path:\filename.dmp full=y rows=y grants=y;

n i am using 8i because our client is on 8i we can't force him.

Attachment: tts.JPG
(Size: 89.01KB, Downloaded 2971 times)

[Updated on: Wed, 20 August 2014 07:18]

Report message to a moderator

Re: trasportable tablespace error during export [message #622007 is a reply to message #621995]

Wed, 20 August 2014 07:22

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

@michel sorry i said backup , actually my requirement is to export a dump file and i am developer not dba , i am having basic knowledge about dba's task Smile

[Updated on: Wed, 20 August 2014 07:22]

Report message to a moderator

Re: trasportable tablespace error during export [message #622012 is a reply to message #622007]

Wed, 20 August 2014 07:49

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

Senior Member
Account Moderator

What is your Windows version (complete version including edition and service pack)?

Report message to a moderator

Re: trasportable tablespace error during export [message #622014 is a reply to message #622012]

Wed, 20 August 2014 08:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

try eliminating the the rightmost semicolon character at the end of the command line.

Report message to a moderator

Re: trasportable tablespace error during export [message #622022 is a reply to message #622014]

Wed, 20 August 2014 09:07

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Agree with BS. I have never put a semi colon, never thought about it. Unlike sqlplus, semi colon won't be recognized in the command line. That's my opinion.

@OP, also, as Oracle suggests, you can try giving prameters one by one when prompted. I don't have 8i to verify, however fingers crossed with Oracle's suggestion.

Report message to a moderator

Re: trasportable tablespace error during export [message #622024 is a reply to message #622022]

Wed, 20 August 2014 09:27

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

Senior Member
Account Moderator

The problem has nothing to do with the semi-colon which is perfectly valid on Windows DOS box and just signal the end of the command and the rest of the line is comment:

E:\>date /t; this is a comment
20/08/2014

Report message to a moderator

Re: trasportable tablespace error during export [message #622034 is a reply to message #622024]

Wed, 20 August 2014 10:23

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Michel,

Thanks for verifying it.

Report message to a moderator

Re: trasportable tablespace error during export [message #622092 is a reply to message #622034]

Thu, 21 August 2014 00:52

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

the issue has been resolved , that was just a temporary error , i restarted my computer and after that everything is working fine.

Thanks everyone. Smile

[Updated on: Thu, 21 August 2014 00:53]

Report message to a moderator

Re: trasportable tablespace error during export [message #622094 is a reply to message #622092]

Thu, 21 August 2014 00:58

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

Senior Member
Account Moderator

Thanks to let us know.
Next time please provide OS information.

Report message to a moderator

Previous Topic:	oracle forms and reports software required for Oracle 12c
Next Topic:	How can I make an existing VB.NET DLL's functions available to stored procedures?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:20:30 CST 2025