ORA-01821 Tried to display a datetime into a readable format by TO_CHAR function, but it failed with ORA-01821. SQL> set heading off; SQL> select TO_CHAR(sysdate,… Read More »How to Resolve ORA-01821: date format not recognized
ORA-01536 Tried to use CTAS to make a table in a tablespace, but it failed with ORA-01536. SQL> create table t1 tablespace users as select… Read More »How to Resolve ORA-01536: space quota exceeded for tablespace
ORA-01950 In this post, we introduce some error patterns of ORA-01950 as below: CREATE TABLE INSERT INTO ALTER TABLE CREATE TABLE Tried to create a… Read More »How to Resolve ORA-01950: no privileges on tablespace 'USERS'
Grant Tablespace Quota Since quota usage limitation is not an object privilege, we can't grant it like this: SQL> grant quota 100g on erpapp_tbs_01 to… Read More »Grant Quota Unlimited on Tablespace to User
ORA-01952 Let's see some error patterns of ORA-01952. CREATE TABLE ALL PRIVILEGES UNLIMITED TABLESAPCE 1. CREATE TABLE Tried to take a privilege away from a… Read More »How to Resolve ORA-01952: system privileges not granted to
ORA-01439 ORA-01439 means that the data type of a column you want to change is not empty, you have to make it empty first, then… Read More »How to Resolve ORA-01439: column to be modified must be empty to change datatype
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 »Prepare Tablespace before Data Migration