Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1652: unable to extend temp segment by 512 in tablespace
"suresh" <softgem_at_gmail.com> wrote in message
news:1128699592.658391.144070_at_f14g2000cwb.googlegroups.com...
>I created a database called desksite and a user as
>
> create user insite_adm identified by testing
> grant CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM to
> insite_adm;
>
>
> create tablespace insite
> datafile 'E:\oracle\oradata\insite\insite_data.dbf'
> size 100M
> extent management local uniform size 4M
>
>
> CREATE TABLE insite_adm.account (
> account_id varchar2 (24) NOT NULL,
> supplier_code varchar2 (4) NOT NULL,
> name varchar2 (100) NOT NULL,
> account_code varchar2 (100) NOT NULL,
> description varchar2 (1000) NOT NULL,
> active_flag number(1) NOT NULL
> )
> ;
>
> CREATE TABLE insite_adm.account_site (
> account_id varchar2 (24) NOT NULL,
> site_id varchar2 (24) NOT NULL
> )
> ;
>
> First table gets created and looks like it takes all the space,
> because when I look at user_segments; I get
>
> segment_name|tablespace_name|bytes|blocks|extents|initial_extent|pct_increase|freelists
> ACCOUNT|INSITE|4194304|512|1|4194304|0|1
>
>
> I am getting this error when I try to create tables from insite_adm,
>
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> INSITE
>
>
> Please anyone can help me?
>
Enlarge the datafiles of the INSITE tablespace if they are not set to AUTOEXTEND ? Matthias Received on Fri Oct 07 2005 - 11:15:06 CDT