i have an oracle database 'testdb' and a java application which using this database.
when any database user connect to this database by this java application, it should be detected at first, if this database exisits and does not have any tables. i.e, the database should be empty.
following statement works if the database user has whole permission on database.
select count(*) from dba_tables where owner='testdb'
the question is:
if database user doesn't have permission on "dba_tables", this statement can not be executed.
are there any way to let such database use to find out, if this database exisits and does not have any tables?