OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » export problem

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

export problem [message #209710]

Sun, 17 December 2006 05:28

baju
Messages: 12
Registered: December 2006

Junior Member

hi,
working with export i have faced some problems.

i have written a stored procedure which will execute os command.

with this procedure i want to execute the following exp command:

exp xxx/xxx@xxx FILE="xx.dmp" LOG="xx.log" OWNER=xx DIRECT=Y statistics=NONE CONSISTENT=Y

it works fine.

but problem is that it takes too much time to complete as compare with executing normal shell exp command(provided above).

what is the problem?
plz help me.
thanks

Report message to a moderator

Re: export problem [message #209711 is a reply to message #209710]

Sun, 17 December 2006 05:34

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

Senior Member
Account Moderator

I think this is an overkill for a simple export job.
If you are calling it from pl/sql using PRO*C or JAVA, there is this unwanted overhead (which is little in many cases).
>>takes too much time to complete as compare with executing normal shell exp
Is that a consitent case? Did try both the options in the exact load conditions?
>> OWNER=xx
Is the stored procedure in the same schema as the OWNER?
>>DIRECT=Y
Idea of DIRECT=y is to bypass the SQL Engines.
If you call it from pl/sql, it may be defying the parameter.
I am not sure about this. Will have to set up a test case.

Regards~

Report message to a moderator

Re: export problem [message #209802 is a reply to message #209711]

Sun, 17 December 2006 22:52

baju
Messages: 12
Registered: December 2006

Junior Member

yes i am calling it from pl/sql using JAVA.

i have not tried with consistent=N. now i am checking it.
no, the same problem with the option consistent=N.
the problem is that it halts a long time at some position.i am watching the progress with the log file.on the log file, suppose,at size 3853 there is no progress,it halts a long time.

Is the stored procedure in the same schema as the OWNER?
yes

should i exclude direct option?

thanks

Report message to a moderator

Re: export problem [message #209911 is a reply to message #209802]

Mon, 18 December 2006 07:18

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

Senior Member
Account Moderator

Consistent=n has nothing to do with this.
>>should i exclude direct option?
Try it~.

Report message to a moderator

Previous Topic:	Backup database from client
Next Topic:	catalog database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:46:18 CST 2024