Home » Server Options » Data Guard » database_properties (oracle 12c Windows 2012)
database_properties [message #672707] Thu, 25 October 2018 06:05 Go to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi ALL,

I have just noticed a thing.

In the view of "database_properties", all the default and permanent settings are listed.
But not about the UNDO tbs information.

We could change the permanent tablespace of TEMP as well as DATA, the same way as UNDO.

Then why it is not included in it.

Regards
M.krish
Re: database_properties [message #672709 is a reply to message #672707] Thu, 25 October 2018 06:18 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
The undo tablespace is an attribute of the instance, not of the database. It has to be, otherwise RAC wouldn't be possible.
Re: database_properties [message #672714 is a reply to message #672709] Thu, 25 October 2018 06:51 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi John

Yes, thanks for the reply.

Regards
M.krish
Re: database_properties [message #672726 is a reply to message #672714] Thu, 25 October 2018 10:51 Go to previous message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So it's an instance property (you can see in v$system_parameter) not a database one.

Previous Topic: ORA-00308: -- DR looking for older archive logfiles
Next Topic: Advantage of having Standby redo logs
Goto Forum:
  


Current Time: Sun Dec 08 10:01:17 CST 2019