Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: URGENT..not importing previous export!!!!!!!!

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

From: Gupta, Brijesh <Brijesh.Gupta_at_Airliquide.com>
Date: Wed, 02 May 2001 11:08:02 -0700
Message-ID: <F001.002F7865.20010502100626@fatcity.com>

"<FONT
color=#000000> import the exported files after making the same structue(tablespace and users) as there were in previous install."
<SPAN

class=620340417-02052001> 
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.
<SPAN

class=620340417-02052001> 
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.
<SPAN

class=620340417-02052001> 
Try
this

-- 
create fresh 8.1.5 database
-- run 
catexp.sql
and 
import complete database.

<SPAN
class=620340417-02052001> 
<SPAN
class=620340417-02052001>Brijesh <FONT face=Tahoma size=2>-----Original Message-----From: Saurabh Sharma [mailto:saurabhs_at_fcsltd.com]Sent: Wednesday, May 02, 2001 2:46 AMTo: Multiple recipients of list ORACLE-LSubject: 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.
Received on Wed May 02 2001 - 13:08:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US