Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespace and table without DOT

846914Dec 22 2011 — edited Dec 23 2011

Hello Everyone

I have a very simple SQL query and a complicated question :)

Let us consider a SQL query - "*select password from bank.users*". How can I remove the dot character and execute the same query. I cannot login as a different user or copy / move tables. However I can access users table from bank tablespace name in the table all_tab_columns

Any help would be greatly appreciated!

regards
phani

Edited by: user10855645 on Dec 22, 2011 2:34 AM

This post has been answered by John Spencer on Dec 22 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2012

Added on Dec 22 2011

#general-database-discussions

11 comments

534 views