Home » RDBMS Server » Server Utilities » About RESUMABLE, RESUMABLE_NAME parameter (Oracle 10.2.0.1.0)
About RESUMABLE, RESUMABLE_NAME parameter [message #592384] Wed, 07 August 2013 06:50 Go to next message
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 #592387 is a reply to message #592384] Wed, 07 August 2013 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean example?
RESUMABLE -> not needed, it is resumable by default
RESUMABLE_NAME -> a name
RESUMABLE_TIMEOUT -> a value in seconds, default 2 hours, see the parameter in Reference manual

Quote:
what happens if mount point error occurs?


Check it and tell us.

Regards
Michel
Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592678 is a reply to message #592384] Sat, 10 August 2013 18:41 Go to previous messageGo to next message
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:11
RESUMABLE -> 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:20
can 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 #592686 is a reply to message #592678] Sun, 11 August 2013 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Lalit Kumar B wrote on Sun, 11 August 2013 01:41
Michel Cadot wrote on Wed, 07 August 2013 18:11
RESUMABLE -> 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.


So how does it come I never put it in the command line or parameter file and my impdp sessions are resumable as I can often saw it?

Regards
Michel

Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592687 is a reply to message #592686] Sun, 11 August 2013 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, your link is about SQL*Loader, and I talk about Data Pump.
It seems the default values are different.

Regards
Michel
Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592696 is a reply to message #592687] Sun, 11 August 2013 03:02 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I have learnt something today! And I haven't even had breakfast yet.
RESUMABLE is enabled, by default, for a data pump import. I've just tested it (release 11.2.0.3)
Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592700 is a reply to message #592696] Sun, 11 August 2013 05:39 Go to previous messageGo to next message
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:32
I 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 #592805 is a reply to message #592700] Mon, 12 August 2013 08:07 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
ok, then, how about for 10g Datapump,is it enabled? or only for 11.2.0.3 ?


Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592806 is a reply to message #592805] Mon, 12 August 2013 08:10 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
srajagopal wrote on Mon, 12 August 2013 14:07
ok, 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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
srajagopal wrote on Mon, 12 August 2013 18:37
ok, 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)
Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592892 is a reply to message #592866] Tue, 13 August 2013 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
To make sure that whatever we have posted is 100% true, I verified the docs,


You assume the docs is always true which is not the case, many bugs in them. Wink

Regards
Michel
Re: About RESUMABLE, RESUMABLE_NAME parameter [message #592915 is a reply to message #592892] Tue, 13 August 2013 01:44 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Agree Michel. But in this case, it is just parameter default values, a simple test would cross-verify.
Previous Topic: sql loader
Next Topic: SQL Loader utility
Goto Forum:
  


Current Time: Thu Mar 28 05:06:24 CDT 2024