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>


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

Original text of this message