Oracle Temporary table Usage Supplement

oracle| temporary table 1, when the specified temporary table is on commit preserve rows (sessions), in the current session as if you want to drop the table, Oracle prompts:
DROP TABLE Student

*

ERROR at line 1:

Ora-14452:attempt to create, alter or drop a index on temporary table already

If you want to delete such a table, there are two methods: one is to exit this session, and then login again, and then execute the drop TABLE command, the second is in the current session of the first truncate, that is, the simulation exit session Oracle to operate (truncated data), Then execute the drop table.

2, all temporary data will be stored in the current user's temporary table space (each user can create a table space).
3. When creating a temporary table, you can also specify a temporary table space.