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-01950: no privileges on tablespace

by Ed Chen
September 7, 2022November 2, 2022

ORA-01950 Tried to create a new table or insert some data into the table, but it failed with ORA-01950. CREATE TABLE SQL> create table t0… Read More »

How to CTAS Tablespace

by Ed Chen
July 28, 2022October 1, 2022

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 an Empty Table by CTAS

by Ed Chen
November 24, 2021October 30, 2021

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 21, 2022

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, 2020April 19, 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 »