SQL> drop tablespace users including contents and datafiles;
drop tablespace users including contents and datafiles
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace
SQL> alter database default tablespace user1;
Database altered.
SQL> drop tablespace users including contents and datafiles;
Tablespace dropped.
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
ORACLE_OCM USER1
OJVMSYS USER1
SYSKM USER1
XS$NULL USER1
GSMCATUSER USER1
MDDATA USER1
AUDSYS USER1
DIP USER1
SYSDG USER1
SPATIAL_CSW_ADMIN_USR USER1
SPATIAL_WFS_ADMIN_USR USER1
GSMUSER USER1
SYSBACKUP USER1
SYSTEM SYSTEM
SYS SYSTEM
Day: July 25, 2021
How To Change SYS Password On ExaCC
Changing Oracle Database SYS user password is more complicated in Exacc Gen 2 environment.
The following should be considered, and takes action appropriately when changing SYS user password:
- SYS Password Changing( Not using Alter User …)
- ExaCC Database Backup Reconfiguration
- A Secure External Password Store (SEPS) SYS Password Update in Keystore
- TDE Wallet Password Changing Recommended
- DG Standby Site Update
Subscribe to get access
Read more of this content when you subscribe today.