What kind of error you are getting from the import?
Since you already have created the tablespaces and users in your new
database, did you put "IGNORE=Y" when you perform the import?
Winnie
--
<\ /> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~
(@ @) @}-`-,-`-,------- Winnie Liu ------',-'-,-'-,-{@ `~`~
/ V \ Oracle Database Administrator `~`~
o--m-m--o Infonet Services Corporation `~`~
##### mailto:[EMAIL PROTECTED] `~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
"Gupta, Brijesh"
<Brijesh.Gupta@Airli To: Multiple recipients of list
ORACLE-L
quide.com> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: URGENT..not importing
previous
export!!!!!!!!
05/02/01 11:06 AM
Please respond to
ORACLE-L
" 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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
