Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating table in new tablespace
bluebody wrote:
>
> Steve Phelan <stevep_at_no-spam.pmcgettigan.demon.co.uk> wrote in article
> <33C4D41F.58D48B09_at_no-spam.pmcgettigan.demon.co.uk>...
> >
> > If it's a 'temp' segment - NOT a 'table' segment - look at the
> > 'temporary tablespace' setting of the user you are creating the table
> > under. Seems to me that that is where your problem lies, not in the
> > actual new table's tablespace. You may have to change or increase the
> > size of the temporary tablespace.
> >
> > Steve Phelan.
> >
> I have my user setting pointing to a large temp tablespace so I don't think
> that is the problem. I tried creating an empty table by defining all the
> columns manually and still get the same error.
I have the following suggestions:
HERE IS SOME sample code that should help
set pagesize 50
set timing on
undefine PLAN_ID
delete from plan_table
where statement_id = '&&PLAN_ID'
/
explain plan set statement_id = '&PLAN_ID' into plan_table for
SELECT < your sql goes here >
ename from emps
/
commit;
rem
rem Generate the plan
rem
column plan format a70
select lpad(' ',3*level)||operation||'('||options||')'||
object_name||' '||object_type
from plan_table
connect by prior id = parent_id and
statement_id = '&PLAN_ID'
start with id =1 and statement_id = '&PLAN_ID'
/ Received on Thu Jul 10 1997 - 00:00:00 CDT