COLUMN property_name FORMAT A30
COLUMN property_value FORMAT A30
COLUMN description FORMAT A50
SET LINESIZE 200
SELECT *
FROM database_properties
WHERE property_name like '%TABLESPACE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ ------------------------------ --------------------------------------------------
DEFAULT_TEMP_TABLESPACE TEMP1 ID of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE SYSTEM Default Permanent Tablespace ID
SQL> ALTER DATABASE DEFAULT TABLESPACE USERS ;
ALTER DATABASE DEFAULT TABLESPACE USERS
*
ERROR at line 1:
ORA-12916: Cannot use default permanent tablespace with this release
if " *.compatible='9.2.0.0.0' " this parameter set then you can't change .
Search This Blog
Total Pageviews
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ► 2011 (362)
No comments:
Post a Comment