| About RESUMABLE, RESUMABLE_NAME parameter [message #592384] |
Wed, 07 August 2013 06:50  |
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
|
Senior Member |
|
|
can anybody show statement example of RESUMABLE, RESUMABLE_NAME, RESUMABLE_TIMEOUT along with exp command..,in a real time scenario,
what happens if mount point error occurs.,
?
|
|
|
|
|
|
| Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592678 is a reply to message #592384] |
Sat, 10 August 2013 18:41  |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 07 August 2013 18:11RESUMABLE -> not needed, it is resumable by default
No. The Resumable parameter is disabled by default. Default value is FALSE. To enable, it needs to be set RESUMABLE=true.
srajagopal wrote on Wed, 07 August 2013 17:20can anybody show statement example of RESUMABLE, RESUMABLE_NAME, RESUMABLE_TIMEOUT along with exp command
The RESUMABLE parameter is used to enable and disable resumable space allocation. RESUMABLE_NAME and RESUMABLE_TIMEOUT are its associated parameters.
While using them as statements you need not out use underscore(_).
For example, you can use them to switch session mode -
ALTER SESSION ENABLE RESUMABLE;
ALTER SESSION DISABLE RESUMABLE;
ALTER SESSION ENABLE RESUMABLE TIMEOUT 3600;
Managing Resumable Space Allocation
Resumable Space Allocation by Tim Hall
Resumable parameters
|
|
|
|
|
|
|
|
|
|
| Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592700 is a reply to message #592696] |
Sun, 11 August 2013 05:39 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
John Watson wrote on Sun, 11 August 2013 13:32I have learnt something today!
+1
Quote:RESUMABLE is enabled, by default, for a data pump import. I've just tested it (release 11.2.0.3)
I have just checked the docs, and it is enabled by default for data pump export too!
|
|
|
|
|
|
| Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592806 is a reply to message #592805] |
Mon, 12 August 2013 08:10 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
srajagopal wrote on Mon, 12 August 2013 14:07ok, then, how about for 10g Datapump,is it enabled? or only for 11.2.0.3 ?
When I was curious about import, I made a little test to find out. Lalit looked up export in the docs. If you want to know for 10g, you could try either approach.
|
|
|
|
| Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592866 is a reply to message #592805] |
Mon, 12 August 2013 15:05 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
srajagopal wrote on Mon, 12 August 2013 18:37ok, then, how about for 10g Datapump,is it enabled? or only for 11.2.0.3 ?
I should have mentioned the version. So let me make it crystal clear, whatever I said is 10g onwards.
John - To make sure that whatever we have posted is 100% true, I verified the docs, and found it absolutely true that for both impdp and expdp, resumable parameter is by default true/enabled.
srajagopal - For more information please go through the docs. Google for Oracle® Database Utilities 10g Release 1 (10.1)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
