|Subject:||Oracle9 bare install, OMF, can't see dba_tables...|
|Posted by:||George (george.cro…@excite.com)|
|Date:||30 Nov 2005|
I installed Oracle9, and instead of running dbca, I created my db
instance according to the docs whereby I copied the init.ora file and
modified the parameters therein to generate the control file.
This worked great, and I was able to create my database, and tables in
it. I can execute queries on the tables I created successfully.
However, when I execute
sqlplus> select * from dba_tables;
I always get,
ORA-00942: table or view does not exist
This is true for all_tables, or dba_tablespaces too. Is there some
other trick so I can see all the tables in my db?
Thank you much. Sincerely,