Oracle/PLSQL: ORA-00902 Error

Error:

Cause:

Action:

1. This error occurs when you try to execute a CREATE TABLE or ALTER TABLE statement that contains a datatype that does not exist. List of valid Oracle datatypes.

For example, if you tried to execute the following CREATE TABLE statement:

CREATE TABLE supplier
(	supplier_id	big_number,
	supplier_name	varchar2(50)
);

Since big_number is not a valid datatype, you would receive the following error message:

You could correct this error as follows:.

CREATE TABLE supplier
(	supplier_id	number,
	supplier_name	varchar2(50)
);