ORA-00933

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 »

Alter Database Add Logfile Correctly

by Ed Chen
October 8, 2021April 1, 2022

ALTER DATABASE ADD LOGFILE clause has two different functions, one is to add a new member to an existing group, the other is to create… 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 Oracle Purge RecycleBin

by Ed Chen
November 21, 2020March 15, 2023

In this post, we'll talk about the following topics. Feature of Recyclebin Prerequisite of Using Recyclebin Ways to Purge Recyclebin Feature of Recyclebin Since 10g,… Read More »