Home » RDBMS Server » Backup & Recovery » excluding tablespace from flashback database
excluding tablespace from flashback database [message #249046] Tue, 03 July 2007 03:00 Go to next message
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.
Re: excluding tablespace from flashback database [message #249048 is a reply to message #249046] Tue, 03 July 2007 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: excluding tablespace from flashback database [message #249172 is a reply to message #249048] Tue, 03 July 2007 10:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
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 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yw Wink
Re: excluding tablespace from flashback database [message #249210 is a reply to message #249201] Tue, 03 July 2007 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Always nice to learn. Smug

Regards
Michel
Re: excluding tablespace from flashback database [message #249211 is a reply to message #249210] Tue, 03 July 2007 11:19 Go to previous messageGo to next message
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.
Re: excluding tablespace from flashback database [message #249285 is a reply to message #249046] Tue, 03 July 2007 23:22 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I am here to see you all.
Previous Topic: Exp/Imp ,Max Buffer size value
Next Topic: error in flashing back database,
Goto Forum:
  


Current Time: Fri Dec 02 20:43:18 CST 2016

Total time taken to generate the page: 0.05796 seconds