jcob_l
asked on
undovalue
No value
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
-------------------------- ----
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
6 rows selected.
SQL> show parameter UNDOTBS1
Name type value not here..
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
--------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
6 rows selected.
SQL> show parameter UNDOTBS1
Name type value not here..
ASKER
SQL> show parameter UNDOTBS1
SQL> show parameter UNDO_TABLESPACE;
NAME TYPE VALUE
-------------------------- ---------- ----------- -------------------------- ----
undo_tablespace string UNDOTBS1
SQL> SQL>
But where is
undo_management
undo_retention
undo_tablespace information
Those should be listed..
SQL> show parameter UNDO_TABLESPACE;
NAME TYPE VALUE
--------------------------
undo_tablespace string UNDOTBS1
SQL> SQL>
But where is
undo_management
undo_retention
undo_tablespace information
Those should be listed..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
SQL> show parameter UNDO_TABLESPACE