OraFAQ Forum: Backup & Recovery » excluding tablespace from flashback database

Home » RDBMS Server » Backup & Recovery » excluding tablespace from flashback database

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

excluding tablespace from flashback database [message #249046]

Tue, 03 July 2007 03:00

prince973
Messages: 37
Registered: November 2006

Member

hi all,
i have a question regarding excluding tablespace from flashback database, which is new feature on oracle 10g,
what is the circumstances that makes an adminitrator would like to exclude a certain tablespace from flashback database,
pls advise.
regards.

Report message to a moderator

Re: excluding tablespace from flashback database [message #249048 is a reply to message #249046]

Tue, 03 July 2007 03:02

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

Senior Member
Account Moderator

You can't.

Regards
Michel

Report message to a moderator

Re: excluding tablespace from flashback database [message #249172 is a reply to message #249048]

Tue, 03 July 2007 10:03

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

YEs ..
Excluding a Tablespacefrom Flashback:

SQL>ALTER TABLESPACE [tablespace] FLASHBACK OFF;


SQL> SELECT TABLESPACE_NAME, FLASHBACK_ON
2> FROM V$TABLESPACE;

[Updated on: Tue, 03 July 2007 10:04]

Report message to a moderator

Re: excluding tablespace from flashback database [message #249196 is a reply to message #249172]

Tue, 03 July 2007 10:55

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

Senior Member
Account Moderator

Thanks for the correction. Embarassed

Regards
Michel

[Updated on: Tue, 03 July 2007 11:18]

Report message to a moderator

Re: excluding tablespace from flashback database [message #249201 is a reply to message #249196]

Tue, 03 July 2007 11:07

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Report message to a moderator

Re: excluding tablespace from flashback database [message #249210 is a reply to message #249201]

Tue, 03 July 2007 11:18

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

Senior Member
Account Moderator

Always nice to learn. Smug

Regards
Michel

Report message to a moderator

Re: excluding tablespace from flashback database [message #249211 is a reply to message #249210]

Tue, 03 July 2007 11:19

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

mistakes makes the man perfect.. Laughing

i did lot of mistakes here and every time you correct me and i learn more n more from those mistakes.

Report message to a moderator

Re: excluding tablespace from flashback database [message #249285 is a reply to message #249046]

Tue, 03 July 2007 23:22

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I am here to see you all.

Report message to a moderator

Previous Topic:	Exp/Imp ,Max Buffer size value
Next Topic:	error in flashing back database,

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 23:34:40 CDT 2024