Hi all,

Just something to trick u guys up ... CAN A TEMPORARY TABLESPACE BE
PERMANENT? Or is that a wrong question where the questioner means can u
create tables in temporary tablespaces ... ??? If users are not assigned
temporary tablespace, what tablespace is used for sorting, SYSTEM?

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


Oracle LazyDBA home page