Export: Release 10.2.0.1.0 - Production on Thursday, 31 May, 2007 10:14:20It means that you forgot to grant a quota on the default tablespace of the user, in this case named YOCOYA.
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "YOCOYA.SYS_EXPORT_TABLE_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-01950: no privileges on tablespace 'USERS'
alter user YOCOYA quota n M on USERSwill fix the problem unless the total allowance of n megabytes is insufficient to carry out the export, in which case you will get:ORA-31626: job does not exist
ORA-31633: unable to create master table "YOCOYA.SYS_EXPORT_TABLE_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-01536: space quota exceeded for tablespace 'USERS'
See message translations for ORA-31626, ORA-31633, ORA-01950, ORA-01536 and search additional resources.
1 comment:
Worse than this:
The temp table Oracle creates has a CLOB column, which requires 3 contiguous blocks in a single extent.
If you have a default tablespace with uniform extent size set, and the uniform extent size is less than 3 blocks, then DataPump cannot create the table. In my case, uniform extent size of 16k with an 8k block size. The error message is
ORA-03237: Initial Extent of specified size cannot be allocated in tablespace.
Post a Comment