Database Administration (MOSC)

MOSC Banner

What is the reason for duplicate entry in sys.props$ and how to delete it?

edited Aug 12, 2013 12:46AM in Database Administration (MOSC) 2 commentsAnswered
Hi,
Please Advice

What is the reason for duplicate entry in sys.props$ and how to delete it?

select name,value$ from sys.props$ where name like '%TABLESPACE%'

NAME VALUE$
------------------------------ ------------
DEFAULT_TEMP_TABLESPACE TEMP
DEFAULT_PERMANENT_TABLESPACE USERS
DEFAULT_TEMP_TABLESPACE SYSTEM
DEFAULT_PERMANENT_TABLESPACE SYSTEM

Regards,
Ola

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center