Re: SYSTEM tablespace defragmentation...

From: Janos Geller <jgeller_at_panix.com>
Date: 1995/05/18
Message-ID: <3pg62l$gnp_at_panix.com>#1/1

Stefano UNTERNAEHRER (unter_at_mecati.mecasoft.ch) wrote:

: $ 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

Your problem (which is a recurring one) is that you didn't run the script creating the internal views for exp/imp. On my system it's in $ORACLE_HOME/rdbms/admin/catexp.sql. You might have to run some other scripts too after database creation (like the one creating DBA views), I'd check all the SQL scripts in this directory.

Hope this helps: Janos Received on Thu May 18 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Stephen Newhouse: "Re: SYSTEM tablespace defragmentation..."
Previous message: spook_at_clark.net: "Re: Oracle 7 Server weirdness"
In reply to: Stefano UNTERNAEHRER: "SYSTEM tablespace defragmentation..."
Next in thread: Stephen Newhouse: "Re: SYSTEM tablespace defragmentation..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message