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

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Thu, 03 May 2001 02:31:34 -0700
Message-ID: <F001.002F80C1.20010503023522@fatcity.com>

I think you have taken a full database export from 8.0.4 and you have created the database and other necessary datafiles. when importing a full database export, u need to only have the database created with system tablespace and when u import the same,it will create the datafiles and also the data will be imported.

HTH.

--

On Wed, 02 May 2001 22:50:22  
 Saurabh Sharma wrote:


>hi winnie,

>

>it got me errors like..

>* IMP-00015: following statement failed because the object already exists:

>* IMP-00017: following statement failed with ORACLE error 1119:

> "CREATE TABLESPACE "ROLLBACK_DATA" DATAFILE

>'G:\ORANT\DATABASE\RBS1ORCL.ORA"  ..........

>* IMP-00003: ORACLE error 1536 encountered

>* ORA-01536: space quota exceeded for tablespace 'USER_DATA'

>

> these are corrected when i increased the quota granted to users. and

>modified the path of datafile creation as according to new locations.

>

>any more suggestions in this regard are highly welcomed.

>thanks.

>

>saurabh

>

>



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: csvenkata_at_lycos.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).

Received on Thu May 03 2001 - 04:31:34 CDT