Table name contains "." dot, How to drop the table ?
Hi All,
I was importing the table into test env from production db. I used remap_table=prod_user.tb_name:test_user.tb_name. Oracle did consider "test_user.tb_name" as table name and imported into test database.
I am trying to drop the table from sys user but oracle looking up for the user " test_user" and throwing user is not available.
I don't know the password for the real owner of the table "test_user:tb_name" so I was trying to drop the table from sys user.
How can I drop the table with dot "." in table name ?