Home » RDBMS Server » Backup & Recovery » export problem
export problem [message #209710] Sun, 17 December 2006 05:28 Go to next message
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




Re: export problem [message #209711 is a reply to message #209710] Sun, 17 December 2006 05:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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~
Re: export problem [message #209802 is a reply to message #209711] Sun, 17 December 2006 22:52 Go to previous messageGo to next message
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
Re: export problem [message #209911 is a reply to message #209802] Mon, 18 December 2006 07:18 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Consistent=n has nothing to do with this.
>>should i exclude direct option?
Try it~.
Previous Topic: Backup database from client
Next Topic: catalog database
Goto Forum:
  


Current Time: Sat Dec 10 13:02:07 CST 2016

Total time taken to generate the page: 0.08093 seconds