I stucked while creating table and may I know that how many table create in temporary tablespace and max size?
Kindly share your valuable views on it so I can assist further, Its urgent, kindly reply soon.
Thanks in advance.
You can create only table which is mainly for sorting for SQL queries and sorting for global temporary tables. You can't create any other table because the data will be flushed out.
Dear Sugandh you can not create a table in tempfile oracle automatically create a file when rows comes for shorting even you can not give the quota in temporary tablespace.
Temporary tablespace is for sorting purpose(its temporary not permanent to store data).
Sign up for STechies
Ask Question From Our Experts