Answer the question
In order to leave comments, you need to log in
How to import full export into Oracle 9i clean base?
All the best.
Oracle DBMS 9.2.0.7 on Linux RedHat Enterpise Server 4
had a problem when importing a full export, I've never done this before, I don't know where to dig :(
I'm doing it on the same physical server
exp userid=\'/ as sysdba\' buffer=20000000 file=$DUMP_FILE_NAME $EXPORT_WHAT &> $LOG_FILE_NAME
CREATE DATABASE DBNAME20
USER SYS IDENTIFIED BY pass
USER SYSTEM IDENTIFIED BY pass
LOGFILE
GROUP 1 (
'/oradata/DBNAME/redo/redo01.log',
'/oradata/DBNAME/redo2/redo01.log',
'/oradata/DBNAME/redo3/redo01.log'
) SIZE 100M,
GROUP 2 (
'/oradata/DBNAME/redo/redo02.log',
'/oradata/DBNAME/redo2/redo02.log',
'/oradata/DBNAME/redo3/redo02.log'
) SIZE 100M,
GROUP 3 (
'/oradata/DBNAME/redo/redo03.log',
'/oradata/DBNAME/redo2/redo03.log',
'/oradata/DBNAME/redo3/redo03.log'
) SIZE 100M
MAXINSTANCES 1
MAXLOGMEMBERS 3
MAXLOGFILES 5
MAXLOGHISTORY 10
MAXDATAFILES 100
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8
DATAFILE '/oradata/DBNAME/data/system01.dbf' SIZE 600M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/DBNAME/temp/temp01.dbf' SIZE 256M REUSE
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oradata/DBNAME/undo/undotbs01.dbf' SIZE 500M REUSE
;
imp system/hoqualb5 file=/vol/data1/db-backups/important_backups/expbkup.dmp log=~/imp.log full=y
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully
Answer the question
In order to leave comments, you need to log in
You do not have a dictionary, you need to run at least the standard
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
and then see what else is missing. If some components were used, then it is necessary to run scripts for the dictionary on them
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question