The database is migrated today from MySQL to Oracle, but MySQL has a user table named user, while the user is an oracle
A migration error is reported for a table under the sys account, but this table is displayed in Oracle. When you drop table user, the system prompts that the table name is invalid. The deletion method is as follows:
Oracle does not allow you to name a table name starting with a number. This table should be imported from somewhere. It is automatically created with double quotation marks, except that double quotation marks are not displayed during viewing.
SQL> Create Table 123 (id1 number );
Create table123 (id1 number)
*
Error at line1:
ORA-00903: Invalid table name
SQL> Create Table "123" (id1 number );
Table created.
SQL> drop table 123;
Drop table 123
*
Error at line1:
ORA-00903: Invalid table name
SQL> drop table "123 ";
Table dropped.
SQL>