RE: URGENT..not importing previous export!!!!!!!!

Remember use ignore=yes to ignore create errors on existing tables, users. If you don't, the import will probably fail.

>>> Brijesh.Gupta_at_Airliquide.com 05/02/01 02:06PM >>>
" 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-----
Sent: Wednesday, May 02, 2001 2:46 AM
To: Multiple recipients of list ORACLE-L

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.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).