OraFAQ Forum: Server Utilities » Hot backup of tablespaces

Home » RDBMS Server » Server Utilities » Hot backup of tablespaces

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

Hot backup of tablespaces [message #506918]

Wed, 11 May 2011 17:52

theon
Messages: 6
Registered: May 2011

Junior Member

Is the tablespace actually off-line when doing a user-managed hot backup? I know the data blocks are copied into a redo stream but I am not sure if that means it(tablespace) is actually on-line or off-line.

Report message to a moderator

Re: Hot backup of tablespaces [message #506919 is a reply to message #506918]

Wed, 11 May 2011 17:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is the tablespace actually off-line when doing a user-managed hot backup?
no

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Like #4 & #5!

[Updated on: Wed, 11 May 2011 18:22]

Report message to a moderator

Data Pump [message #506924 is a reply to message #506919]

Wed, 11 May 2011 20:36

theon
Messages: 6
Registered: May 2011

Junior Member

Sorry, I am using oracle version 11.2.0.1 on windows 7 home platform.

Looking through the oracle documentation I cannot find where one can or cannot import triggers during an import with a data pump. I did see where one can import triggers using the older import utility.

Report message to a moderator

Re: Data Pump [message #506925 is a reply to message #506924]

Wed, 11 May 2011 20:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

No Oracle version is supported on any Home Edition.

impdp help=yes
impdp supports both EXCLUDE & INCLUDE qualifiers

Report message to a moderator

Re: Data Pump [message #506961 is a reply to message #506924]

Thu, 12 May 2011 01:04

Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do NOT mix up different questions in the same topic, no one will then be able to understand to which question an answer will come and if it is correct or not.
You have been able to create a topic, then creare a new one it is not more difficult the second time.

Regards
Michel

Report message to a moderator

Re: Data Pump [message #507117 is a reply to message #506961]

Thu, 12 May 2011 10:14

theon
Messages: 6
Registered: May 2011

Junior Member

Sorry, I am trying to do several things at once.

Report message to a moderator

Re: Data Pump [message #507119 is a reply to message #506925]

Thu, 12 May 2011 10:19

theon
Messages: 6
Registered: May 2011

Junior Member

I am running an iso image of Oracle 11 on Windows 7 home premium with a VM player and an SSH client for SQL. So far it works.

Thanks for the answers.

Report message to a moderator

Previous Topic:	ORA-02298: - parent keys not found
Next Topic:	sqlloader doesn't work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 15:23:56 CDT 2023