Ed's Logic

How to Resolve ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

by Ed Chen
May 12, 2023April 13, 2023

ORA-01749 Tried to grant some object privilege to the user, but it failed with ORA-01749. SQL> show user USER is "HR" SQL> grant select on… Read More »

How to Resolve ORA-39087: directory name is invalid

by Ed Chen
May 11, 2023May 12, 2023

ORA-39087 Saw errors ORA-39087 and ORA-39070, when tried to export data AS SYSDBA through data pump expdp. [oracle@test ~]$ expdp \"/ as sysdba\" full=y directory=BACKUP_DUMPS… Read More »

Create Table SQL Statement

by Ed Chen
May 10, 2023May 24, 2023

What is the syntax of CREATE TABLE in Oracle? Since the syntax of CREATE TABLE statement can be very flexible and complicated, so using text-based… Read More »

Toad Create Table Example

by Ed Chen
May 9, 2023May 2, 2023

How to create a table in Oracle step by step? To create a new table, we can choose to compose a hand-writing PL/SQL statement which… Read More »

PL/SQL Developer Create Table Example

by Ed Chen
May 8, 2023May 15, 2023

How to create a new table in Oracle? To create a new table, we can choose to compose a hand-writing PL/SQL statement which may be… Read More »

SQL Developer Create Table Example

by Ed Chen
May 5, 2023May 24, 2023

How do I create a new table in Oracle? To create a new table, we can choose to compose a hand-writing SQL statement which may… Read More »

How to Resolve ORA-00924: missing BY keyword

by Ed Chen
May 4, 2023May 5, 2023

ORA-00924 ORA-00924 means that the reserved word BY is missing from the statement at the position where it points out in the error message. ORA-00924… Read More »

How to Resolve ORA-02155: invalid DEFAULT tablespace identifier

by Ed Chen
May 3, 2023March 25, 2023

ORA-02155 Tried to set the default permanent tablespace for an user, but it failed with ORA-02155. SQL> alter user hr default tablespace; alter user hr… Read More »

How to Resolve ORA-00907: missing right parenthesis

by Ed Chen
May 2, 2023March 25, 2023

ORA-00907 ORA-00907 means that SQL parser saw an illegal string or expression where it expects a right parenthesis to close the inner statement. Usually, it's… Read More »

How to Resolve ORA-02263: need to specify the datatype for this column

by Ed Chen
May 1, 2023March 24, 2023

ORA-02263 Tried to create a table, but it failed with ORA-02263. SQL> create table fruits (fruit_name not null, price number); create table fruits (fruit_name not… Read More »

JavaScript is not enabled. Please enable it and reload the page.