OraFAQ Forum: Server Utilities » exp command ending abruptly without any error messages

Home » RDBMS Server » Server Utilities » exp command ending abruptly without any error messages (oracle 9i, windows xp)

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

exp command ending abruptly without any error messages [message #644980]

Mon, 23 November 2015 01:40

vidyatrajan
Messages: 1
Registered: November 2015

Junior Member

when I run the exp command , no tables are getting exported and the utility terminates, final message being

. about to export SYSTEM's tables via Conventional Path ...

No error messages or warnings are reported.

The user has EXP_FULL_DATABASE role assigned and CREATE SESSION privilege

Tried executing the command by giving the name of one single table. Ends in a similar way.

Since no error is reported, unable to find the cause for the problem.

There are no entries in the log file too.

Is the problem with oracle or the OS?

Any help will be appreciated in this direction.

Report message to a moderator

Re: exp command ending abruptly without any error messages [message #644984 is a reply to message #644980]

Mon, 23 November 2015 02:06

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

Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Then copy and paste the complete export session including the command line.

Report message to a moderator

Re: exp command ending abruptly without any error messages [message #645044 is a reply to message #644980]

Tue, 24 November 2015 07:33

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

In addition to Michel's request, the alert log might prove useful too.

Report message to a moderator

Re: exp command ending abruptly without any error messages [message #646663 is a reply to message #644980]

Wed, 06 January 2016 12:21

garan
Messages: 27
Registered: January 2016

Junior Member

Hi

your email is not clear to me

1.Does export command fails for all the modes

Full Database Mode, User Mode, Table Mode

2. Are you doing this in Unix environment Did you check do you permission to create file in the directory you are doing export or the write permission of the directory in which log file is created.

3. Did you check the space available using df -k just wondering if the filesystem is full. If you are doing export of large table the dump file created will occupy more space and it might fail to create due to space issue.

Please provide the exact command and the environment you are doing export like Unix/Windows

garan

Report message to a moderator

Re: exp command ending abruptly without any error messages [message #646664 is a reply to message #646663]

Wed, 06 January 2016 12:25

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

Senior Member
Account Moderator

I doubt you will have any answer from OP.
It is just a waste of time to try (and fail) to envisage all possible errors when the log we asked will tell us the actual and OP refuse to post.
I think he is what we call a 'one-time poster", he comes, posts his question and never comes back.

[Updated on: Wed, 06 January 2016 12:26]

Report message to a moderator

Re: exp command ending abruptly without any error messages [message #646692 is a reply to message #646664]

Wed, 06 January 2016 23:19

garan
Messages: 27
Registered: January 2016

Junior Member

Sir

Thank you for the response

Small suggestion Probably it's good idea to close the thread more than 6 months old

Tek Tips has a policy where they close the thread if it is more than 6months and it will be read only for the users and we will not be able to respond

Report message to a moderator

Re: exp command ending abruptly without any error messages [message #646694 is a reply to message #646692]

Wed, 06 January 2016 23:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

garan wrote on Wed, 06 January 2016 21:19

Sir

Thank you for the response

Small suggestion Probably it's good idea to close the thread more than 6 months old

Tek Tips has a policy where they close the thread if it is more than 6months and it will be read only for the users and we will not be able to respond

Why do you require Big Brother to prevent you from showing responsibility, common sense & constraint?

Report message to a moderator

Previous Topic:	Sqlloader password encryption
Next Topic:	create flat file using stored procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 17:34:19 CST 2025