1, when specified temporary table is on commit preserve rows
Time (session stage), in the current session, the time is going to do DROP, Oracle Tips: Drop Table Student * Error At line 1: ORA-14452: Attempt to create, alter or drop an index on temporary Table Already IN Use If you want to delete this table, the method has two: First, if you have to log in, then log in again, then execute the drop table command; Second, try to use Truncate first in the current session, that is, analog to exit session is time to operate ( Truncate data), then execute the Drop Table. 2. All temporary data will be stored under the current user's temporary table space (the table space can be performed when each user is created). 3. Creating a temporary episode can also specify a temporary table space.
