Re: Problem with impdp

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 11 Oct 2006 14:33:06 GMT
Message-ID: <J6z738.315@igsrsparc2.er.usgs.gov>

> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
> - 64bit Production
> With the Partitioning, OLAP and Data Mining options
> ORA-31626: job does not exist
> ORA-31633: unable to create master table "ADMIN.SYS_IMPORT_FULL_05"
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPV$FT", line 863
> ORA-01647: tablespace 'ORIG_TBS' is read only, cannot allocate space in
> it

Does tablespace ORIG_TBS exist in the database? If so, can you make it read write until after your import is done?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Wed Oct 11 2006 - 09:33:06 CDT