Home » RDBMS Server » Server Utilities » Hot backup of tablespaces
Hot backup of tablespaces [message #506918] Wed, 11 May 2011 17:52 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 20092
Registered: January 2009
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 20092
Registered: January 2009
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 Go to previous messageGo to next message
Michel Cadot
Messages: 54157
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 08:01:41 CDT 2013

Total time taken to generate the page: 0.33163 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.