1 Reply Latest reply on Aug 20, 2019 4:12 PM by Dean Gagne-Oracle

    Datapump export of transportable tablespaces fail

    ajakovcic

      So I'm trying to export metadata of transportable tablespace. I put tablespace in readonly mode and on export I get error that master table cannot be created because file cannob me modified at this time. I noticed that it want to create master table in tablespace that is in read only mode instead in deafult tablespace of user. Any ideas how to force it to write master data in default tablespace of user?

       

      select default_tablespace from dba_users where username='SYS'

       

      DEFAULT_TABLESPACE           

      ------------------------------

      SYSAUX                       

      1 row selected.

       

      select * from dba_data_files where tablespace_name='SYSAUX'

       

      FILE_NAME                                                                      

      --------------------------------------------------------------------------------

         FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS  

      ---------- ------------------------------ ---------- ---------- ---------

      RELATIVE_FNO AUTOEXTENSIBLE   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES

      ------------ -------------- ---------- ---------- ------------ ----------

      USER_BLOCKS ONLINE_STATUS

      ----------- -------------

      /wpostdb/data1/WEBPOS/sysaux02.dbf                                             

              41 SYSAUX                          891289600     108800 AVAILABLE

                41 YES            3.4360E+10    4194302         1280  891224064

           108792 ONLINE      

                                                                                     

      /wpostdb/data1/WEBPOS/sysaux01.dbf                                             

               3 SYSAUX                         1415577600     172800 AVAILABLE

                 3 YES            3.4360E+10    4194302         1280 1415512064

           172792 ONLINE      

                                                                                     

      2 rows selected.

       

      expdp \"/ as sysdba\" PARFILE=TRANS_TBS.par

       

      Export: Release 11.2.0.4.0 - Production on Tue Aug 20 12:49:50 2019

       

      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

       

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      ORA-31626: job does not exist

      ORA-31633: unable to create master table "SYS.SYS_EXPORT_TRANSPORTABLE_05"

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

      ORA-06512: at "SYS.KUPV$FT", line 1038

      ORA-00372: file 6 cannot be modified at this time

      ORA-01110: data file 6: '/wpostdb/data1/WEBPOS/wpost_data03.dbf'