" import the exported files after making the same structue(tablespace and users) as there were in previous install."
 
You don't have to create the users. The import will create it for you. Also in your case you don't have to create the database as the same path already exists as old database.
 
It may be not importing because you have already created the users and when import file tries to create the user it fails and skips it.
 
Try this
-- create fresh 8.1.5 database
-- run catexp.sql
and import complete database.
 
Brijesh
-----Original Message-----
From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 2:46 AM
To: Multiple recipients of list ORACLE-L
Subject: URGENT..not importing previous export!!!!!!!!

hi all,
there is an urgent problem that cropped up while i had some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it.
i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install.
but there is not even a single table import taking place.
will u pls help me in where i'm doing wrong.
and how i could restore the earlier export files in this new database. here's some info that may help..
 
earlier version 8.0.4, sid orcl
new version 8.1.5  , sid apex
no/name of tablespace and users are exactly matching.

Reply via email to