Can't see system information on new DATABASE
From: Peter Lister <ccprl_at_xdm039.ccc.cranfield.ac.uk>
Date: 2 Feb 1994 15:47:53 GMT
Message-ID: <2iohv9$97m_at_xdm001.ccc.cranfield.ac.uk>
Date: 2 Feb 1994 15:47:53 GMT
Message-ID: <2iohv9$97m_at_xdm001.ccc.cranfield.ac.uk>
Hi
I've created a new database, alongside the default 'ora' created at installation (Oracle 7.0.13). I can create things, look at them, create users, the 2nd db starts OK, everything is lovely, EXCEPT I can't see any of the tables which give me information about the new db. It's my understanding that CREATE DATABASE should have done all this. I should add that the first attempt at creating the database failed due to a badly configured rollback_segment line in the parameter file, but I deleted all the files, and recreated the db with no errors.
Any ideas? Example follows. Sorry if this is a FAQ, but I have had singular unsuccess getting at the FTP site.
--
Peter Lister Email: p.lister_at_cranfield.ac.uk
Computer Centre, Cranfield University Voice: +44 234 754200 ext 2828
Cranfield, Bedfordshire MK43 0AL UK Fax: +44 234 750875
--- Widget. It's got a widget. A lovely widget. A widget it has got. ---
Connected as SYSTEM, to the new database....
Connected to:
ORACLE7 Server Release 7.0.13.1.1 - Production
SQL> select * from cat ;
select * from cat
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
On the old one...
Connected to:
ORACLE7 Server Release 7.0.13.1.1 - Production
SQL> select * from cat ;
TABLE_NAME TABLE_TYPE
------------------------------ -----------
CATALOG SYNONYM
COL SYNONYM
DBA_2PC_NEIGHBORS SYNONYM
DBA_2PC_PENDING SYNONYM
DBA_AUDIT_EXISTS SYNONYM
.
.
TABQUOTAS SYNONYM
USER_PRIVS VIEW
USER_PROFILE TABLE
119 rows selected.
SQL>
Received on Wed Feb 02 1994 - 16:47:53 CET
