Removing temporary table empty ora-25152 error, removing ora-25152 Error
Deleting a temporary tablespace or shrinking a temporary tablespace often results in table space occupation.
Next we will handle this situation,
First, find the locked sid:
SELECT a. INST_ID, B. TABLESPACE
, B. segfile #
, B. segblk #
, ROUND (B. blocks * p. VALUE)/1024/1024), 2) size_mb
, A. SID
, A. serial #
, A. username
, A. osuser
, A. program
, A. status
FROM gv $ session
, Gv $ sort_usage B
, Gv $ process c
, Gv $ parameter p
WHERE p. NAME = 'db _ block_size'
AND a. saddr = B. session_addr
AND a. paddr = c. addr
Order by B. TABLESPACE
, B. segfile #
, B. segblk #
, B. blocks;
You can find the sid of the temporary tablespace and serial #
Then, it is the same as ALTER system kill session 'sid, serial # 'to delete.
You can delete the temporary tablespace or contract the temporary tablespace.
The following describes a more convenient method.
Select 'alter system kill session ''' | a. sid | ',' | a. serial # | ''' immediate ;'
From
V $ session,
V $ sort_usage B,
V $ process c,
V $ parameter d
Where
D. name = 'db _ block_size'
And
A. saddr = B. session_addr
And
A. paddr = c. addr
And
B. tablespace = 'temp '-- Name of the temporary tablespace to be shrunk or deleted
Order
B. tablespace,
B. segfile #,
B. segblk #,
B. blocks;
You can end the use of temporary tablespace in batches.
Zookeeper
In the oracle database, you need to create a temporary table to use it. Can you create this table in a temporary table empty?
Yes, of course, but temporary tables and temporary creation of a table are two concepts.
Temporary table is
Create global temporary table...
There are two types: one is to delete data upon submission, and the other is to retain data after submission.
You cannot
The table created by create table is placed in the temporary tablespace.
How to solve the "Cannot update temporary table" error when VF is connected (the original table should not be a temporary table)
That's because you used a temporary table, such as select * from table name into cursor temp.
Then, this temporary table is opened. For some reason, you want to update or modify the database table records, but the data table is not in the current workspace. Therefore, the computer considers it a temporary table in the current workspace, therefore, the system will prompt that the temporary table cannot be updated.