Create Table As Select (CTAS)

How to Resolve ORA-01536: space quota exceeded for tablespace

by Ed Chen
November 10, 2022October 17, 2022

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-00922: missing or invalid option

by Ed Chen
November 9, 2022March 24, 2023

ORA-00922 ORA-00922 means that SQL parser found an invalid option where should be empty or one of other valid options it expects. Since it's a… Read More »

How to Resolve ORA-01950: no privileges on tablespace 'USERS'

by Ed Chen
September 7, 2022February 20, 2023

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 »

Create Table as Select (CTAS) to Tablespace

by Ed Chen
July 28, 2022March 24, 2023

Create Table as Select Tablespace Without specifying tablespace, Create Table as Select (CTAS) will go to the default tablespace of the user. How about specifying… Read More »

How to Create Empty Table by CTAS

by Ed Chen
November 24, 2021January 24, 2023

Empty Table To duplicate a table, the fast way is to use CTAS (Create Table As Select). Sometimes, the only thing you want is an… Read More »

How to Resolve ORA-00933: SQL command not properly ended

by Ed Chen
September 22, 2021February 20, 2023

ORA-00933 ORA-00933 means that you use an unexpected word or phrase at the position where SQL parser knows what qualified keyword should be. Use cases… Read More »

How to Change Column Order and Position

by Ed Chen
May 12, 2021October 7, 2022

One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »

How Oracle Search View Text in ALL_VIEWS

by Ed Chen
November 28, 2020December 9, 2022
2 Comments

ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search some text for… Read More »

How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG

by Ed Chen
November 28, 2020October 24, 2021

ORA-00932 ORA-00932 means that SQL engine wanted to retrieve CHAR strings, but it saw LONG data type, which is unsearchable. So SQL engine refused to… Read More »