Has no intention of the temporary table DBF files deleted, pl/SQL can't normal use now, seek gu-CodePudding

Today accidentally put a temporary table DBF file deleted, carried out in accordance with the online presentation of the alter database datafile 'M: \ oracle11 \ TRD_3 DBF' offline drop, then the alter database open will appear ora - 01147 error, prompt table space of the above documents is in offline state, could you tell me how to do?

CodePudding user response:

Top by oneself, online, etc

CodePudding user response:

Offline only that a data file?

CodePudding user response:

refer to the second floor wmxcn2000 response:

offline only that a data file?

yes, remove this one

CodePudding user response:

Temporary table space does not support offline

CodePudding user response:

reference 4 floor baidu_36457652 response:

temporary TABLESPACE does not support offline.

is that before the create table always reminded me that I can't through what 1024 extension table space, and then according to the way of online ALTER in TABLESPACE * * * _TRD ADD DATAFILE
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ DBFILE \ TRD_2 AUTOEXTEND DBF' SIZE 1024 m 10240 m ON NEXT 8 m MAXSIZE created a few table space, the table space 10 g full up after a while, and suggested the same problem, I will close the database had deleted the file, appeared the question now, pl/SQL can't use, how to solve

CodePudding user response:

reference 5 floor mystery_93 reply:

Quote: refer to 4th floor baidu_36457652 response:

Temporary table space not support offline

is that before the create table always reminded me that I can't through what 1024 extension table space, and then according to the way of online ALTER in TABLESPACE * * * _TRD ADD DATAFILE
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ DBFILE \ TRD_2 AUTOEXTEND DBF' SIZE 1024 m 10240 m ON NEXT 8 m MAXSIZE created a few table space, the table space 10 g full up after a while, and suggested the same problem, I will close the database had deleted the file, appeared the question now, pl/SQL can't use, could you please tell me how to solve

Is you to delete the temporary files? With you now start database to the nomount state and then create pfile from spfile. Then the temp inside the pfile tablespce assigned to the system tablespace, then start to create a temporary tablespace two a deleted, then switch the temporary table space in the past, and then create spfile from pfile. Direct startup and shutdown last try and see. I have no way to help you in the car test

CodePudding user response:

Your library all DOWN, PLSQL even not, of course, you want to go to server SYS user to operate

CodePudding user response:

Temporary table of the building Lord says should be temporary table on business?

You add the data file SYSTEM tablespace? That is about 88 goodbye

CodePudding user response:

refer to the eighth floor minsic78 response:

temporary table of the building Lord said should be a temporary table on business?

You add the data file SYSTEM tablespace? That is about 88 goodbye

yes ah, what if another temporary table space is not enough, do you have a good solution

CodePudding user response:

references 9 f mystery_93 response:

Quote: refer to the eighth floor minsic78 response:

Temporary table of the building Lord says should be temporary table on business?

You add the data file SYSTEM tablespace? That is about 88 goodbye

yes ah, what if another temporary table space is not enough, do you have any good solution

Temporary table space is expanding the temporary table space, temporary table space, you can casually played ~