| drop temp tablespace TEMP01.dbf [message #639960] |
Mon, 20 July 2015 14:06  |
imuharram
Messages: 48
Registered: January 2009
|
Member |
|
|
TEMP01.DBF datafile has a huge size and while trying to drop and a new temp file using below commands
alter database tempfile 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEMP01.DBF' drop including datafiles;
database altered, however, temp01.dbf datafile was not physically deleted
therefore, when executing command
alter tablespace temp add tempfile 'E:\oracle\product\10.1.0\oradata\orcl\TEMP01.DBF' SIZE 500m;
to add a datafile to temp tablespace an error is raised due to having the old datafile
should datafile be deleted manually?
|
|
|
|
|
|
| Re: drop temp tablespace TEMP01.dbf [message #640045 is a reply to message #639963] |
Tue, 21 July 2015 08:57  |
imuharram
Messages: 48
Registered: January 2009
|
Member |
|
|
I gave it another name as suggested.
however, when trying to export database it is terminated unsuccessfully.
It was working fine 4 days ago, but face this disk space problem and wanted to solve it through dropping temp tablespace
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 278
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 147
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ index(idl_char$ i...","Typecheck heap","kgghteInit")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [k2dgetgdnm-5], [604], [ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")
], [], [], [], [], []
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2574
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting foreign function library names for user WORK_ORDER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user WORK_ORDER
About to export WORK_ORDER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ index(idl_ub1$ i_...","Typecheck heap","kgghteInit")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_METADATA", line 2576
ORA-06512: at "SYS.DBMS_METADATA", line 2719
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: drop temp tablespace TEMP01.dbf [message #640157 is a reply to message #640140] |
Thu, 23 July 2015 02:56 |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
No. Previously:
'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEMP01.DBF'
Now:
E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEMP001.DBF
@OP, if the above is correct, you can delete TEMP01.DBF via the O/S. As BlackSwan said, if Oracle is using it the O/S won't let you delete it.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
