Database Administration (MOSC)

MOSC Banner

Table name contains "." dot, How to drop the table ?

edited Apr 10, 2018 8:34PM in Database Administration (MOSC) 11 commentsAnswered

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center