SYSTEM tablespace defragmentation...

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/05/15
Message-ID: <D8MvFL.49J_at_mecati.mecasoft.ch>#1/1


Hello DBA's !

I'm trying to defragment my poor system tablespace... Here is what I have done (hope is complete!):
- exp system/manager inctype=COMPLETE compress=Y full=Y grants=Y constraints=Y

At this moment I've restarted the database and called the imp utility, to let import my old users, grants, tables, rows, indexes, constraints...

$ imp system/manager file=expdat.dmp full=Y

Import: Version 6.0.34.2.1 - Production on Mon May 15 21:04:02 1995 Copyright (c) Oracle Corporation 1979, 1989. All rights reserved. Connected to: ORACLE RDBMS V6.0.34.2.1, transaction processing option - Production

IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA


WHY ?? What am I missing?
I have to create all the users and tables before to import the data? What about the DD tables?

Event with command: imp system/manager file=expdat.dmp show=Y I obtain the same message, so maybe my problem is in the exp file, but why?? At the moment I have reinstalled the old tared directory... :-( I hope to hear some good news from you!

Thank you for any hints,
Stefano

--
                       ____________________________
______________________|    Stefano Unternaehrer    |__________________________
\  Mecasoft SA        |         Oracle DBA         | fax:    +41 93 335 507  /
 \ 6600 Muralto       |     and  PL/SQL, Pro*C     | voice:  +41 93 337 444 /
  \                   |     C, XWindow & Motif     |                       /
  /                   |     Software Developer     | email:                \
 / Switzerland Europe |____________________________|  dba,unter_at_mecasoft.ch \
/________________________)                      (____________________________\
Received on Mon May 15 1995 - 00:00:00 CEST

Original text of this message