Oracle TO_CHAR Example
TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »Oracle TO_CHAR Example
TO_CHAR
How to Resolve ORA-01821: date format not recognized
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
Oracle SQL Reserved Words
Besides ANSI SQL reserved words, Oracle has its own reserved words which are conditionally used in the RDBMS. Here we query V$RESERVED_WORDS to list all… Read More »Oracle SQL Reserved Words
How to Resolve ORA-01536: space quota exceeded for tablespace
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
How to Resolve ORA-01950: no privileges on tablespace 'USERS'
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 Quota Unlimited on Tablespace to User
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
How to Resolve ORA-01952: system privileges not granted to
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
How to Resolve ORA-01439: column to be modified must be empty to change datatype
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
Prepare Tablespace before Data Migration
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
Oracle TO_DATE Example
Oracle TO_DATE function can convert a string into a datetime value which is acceptable for computing or comparing values of datetime type. In other words,… Read More »Oracle TO_DATE Example