CREATE TABLESPACE

How to Resolve ORA-30012: undo tablespace does not exist or of wrong type

by Ed Chen
November 11, 2022March 20, 2023

ORA-30012 Tried to restart a normal, typical database after changing the default undo tablespace, but it failed with ORA-30012. SQL> startup ORACLE instance started. ...… Read More »

Create Tablespace Examples

by Ed Chen
August 22, 2022February 12, 2023

Creating a normal and permanent tablespace is pretty regular practice for a DBA whenever application needs it, comparing to creating a temporary tablespace. In this… Read More »

IMP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022March 20, 2023

IMP_FULL_DATABASE IMP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database imports… Read More »

How to Check Tablespace Creation Date

by Ed Chen
May 30, 2022June 10, 2022

Tablespace Create Time There's no direct way to know the creation date of a tablespace, because either DBA_TABLESPACES or V$TABLESPACE doesn't have such information. But… Read More »

How to Resolve ORA-02216: tablespace name expected

by Ed Chen
May 20, 2022February 12, 2023

ORA-02216 ORA-02216 means that SQL parser finds no identifier at the position where expects a tablespace name. Basically, it's a syntax error. To correct it,… Read More »

How to Resolve ORA-02180: invalid option for CREATE TABLESPACE

by Ed Chen
May 19, 2022February 12, 2023

ORA-02180 There're 2 basic patterns of error ORA-02180 in this post: Missing Tablespace Name Missing Keyword A. Missing Tablespace Name If we didn't specifiy the… Read More »

How to Resolve "Warning: PDB altered with errors."

by Ed Chen
April 11, 2022February 12, 2023
6 Comments

Warning: PDB altered with errors Tried to open a newly cloned or created PDB, but it failed with "Warning: PDB altered with errors". SQL> alter… Read More »

How to Enable Oracle TDE 19c Step by Step

by Ed Chen
August 9, 2021February 12, 2023
8 Comments

Oracle TDE 19c I have talked about how to extract plain text from a normal, non-encrypted data file before. If you're considering a more secure… Read More »

How to Change DB_UNIQUE_NAME of a RAC Database

by Ed Chen
February 3, 2021February 12, 2023

In previous post, we have talked about how to change DB_NAME of a RAC database. In this post, we will talk about how to change… Read More »

Prepare Tablespace before Data Migration

by Ed Chen
December 9, 2020March 27, 2023

In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »