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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g imp woes

Re: Oracle 10g imp woes

From: Andrew Tyson <atyson_at_optus.please.refrain.from.spamming.net>
Date: Sun, 26 Jun 2005 18:04:31 +1000
Message-ID: <42be628c$0$26484$afc38c87@news.optusnet.com.au>

> 1) If you exported the data as DBA, then import it as DBA
> or ensure you have the "IMP_FULL_DATABASE" privilege.

Importing using DBA user system

> 2) Increasing the tabalespace for the import.

Hmmm - I am using a similar size to the source DB for the tablespace. The import is bombing out very early, however even so I would expect the tablespace to grow during the import.

Thanks,
Andrew Received on Sun Jun 26 2005 - 03:04:31 CDT

Original text of this message

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