IMPort / temp segment question 
Author Message
 IMPort / temp segment question
Hi!

I did an IMPort yesterday, and hit the following error:
15-JAN-2001 23:50:48.41:
ORA-1652: unable to extend temp segment by 64000 in tablespace
FIN_DATA_LARGE

Why is Oracle using FIN_DATA_LARGE for temporary storage? FIN_DATA_LARGE is
the tablespace where the imported table was going. The user specified in the
IMP command has tablespace TEMP as temporary tablespace. There must be
something I`m missing...

Thanks!

--
Syltrem
http://www.***.com/ (OpenVMS Web Site)



Sun, 06 Jul 2003 00:17:34 GMT
 IMPort / temp segment question

This is an FAQ. Import is building indexes for you. Before that's
done, "indexes" are temporary segments in the local tablespace.

Yong Huang



Quote:
> Hi!

> I did an IMPort yesterday, and hit the following error:
> 15-JAN-2001 23:50:48.41:
> ORA-1652: unable to extend temp segment by 64000 in tablespace
> FIN_DATA_LARGE

> Why is Oracle using FIN_DATA_LARGE for temporary storage?
FIN_DATA_LARGE is
> the tablespace where the imported table was going. The user specified
in the
> IMP command has tablespace TEMP as temporary tablespace. There must be
> something I`m missing...

> Thanks!

> --
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS Web Site)

Sent via Deja.com
http://www.deja.com/


Sun, 06 Jul 2003 01:17:37 GMT
 IMPort / temp segment question

Quote:
> This is an FAQ. Import is building indexes for you. Before that's
> done, "indexes" are temporary segments in the local tablespace.

> Yong Huang



> > Hi!

> > I did an IMPort yesterday, and hit the following error:
> > 15-JAN-2001 23:50:48.41:
> > ORA-1652: unable to extend temp segment by 64000 in tablespace
> > FIN_DATA_LARGE

> > Why is Oracle using FIN_DATA_LARGE for temporary storage?
> FIN_DATA_LARGE is
> > the tablespace where the imported table was going. The user
specified
> in the
> > IMP command has tablespace TEMP as temporary tablespace. There must
be
> > something I`m missing...

> > Thanks!

> > --
> > Syltrem
> > http://pages.infinit.net/syltrem (OpenVMS Web Site)

> Sent via Deja.com
> http://www.deja.com/

As are uncommitted table inserts.  Any segment that has not yet been
committed is considered temporary.  Essentially the tablespace did not
have enough contiguous space to allocate extent.

--
David Fitzjarrell
Oracle Certified DBA

Sent via Deja.com
http://www.deja.com/



Sun, 06 Jul 2003 01:39:51 GMT
 IMPort / temp segment question
Thanks for your responses. I will put that in my hat!

--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS Web Site)


Quote:

> > This is an FAQ. Import is building indexes for you. Before that's
> > done, "indexes" are temporary segments in the local tablespace.

> > Yong Huang



> > > Hi!

> > > I did an IMPort yesterday, and hit the following error:
> > > 15-JAN-2001 23:50:48.41:
> > > ORA-1652: unable to extend temp segment by 64000 in tablespace
> > > FIN_DATA_LARGE

> > > Why is Oracle using FIN_DATA_LARGE for temporary storage?
> > FIN_DATA_LARGE is
> > > the tablespace where the imported table was going. The user
> specified
> > in the
> > > IMP command has tablespace TEMP as temporary tablespace. There must
> be
> > > something I`m missing...

> > > Thanks!

> > > --
> > > Syltrem
> > > http://pages.infinit.net/syltrem (OpenVMS Web Site)

> > Sent via Deja.com
> > http://www.deja.com/

> As are uncommitted table inserts.  Any segment that has not yet been
> committed is considered temporary.  Essentially the tablespace did not
> have enough contiguous space to allocate extent.

> --
> David Fitzjarrell
> Oracle Certified DBA

> Sent via Deja.com
> http://www.deja.com/



Sun, 06 Jul 2003 02:11:32 GMT
 IMPort / temp segment question
Hi, David,

Can you explain what is an uncommitted segment, preferably with a
screen shot? I think you know what you say but didn't say it clearly.

I know when you create a big index, if you type fast, you can see the
temp segment in your tablespace with SQL*Plus (segment_name is numbers
dot numbers, like '9.2' e.g. and segment_type = 'TEMPORARY'). But a
table you insert a record in before commit is not a temporary segment.

Yong Huang



Quote:

> As are uncommitted table inserts.  Any segment that has not yet been
> committed is considered temporary.  Essentially the tablespace did not
> have enough contiguous space to allocate extent.

> --
> David Fitzjarrell
> Oracle Certified DBA

Sent via Deja.com
http://www.deja.com/


Sun, 06 Jul 2003 03:17:51 GMT
 IMPort / temp segment question

Quote:
> Hi, David,

> Can you explain what is an uncommitted segment, preferably with a
> screen shot? I think you know what you say but didn't say it clearly.

> I know when you create a big index, if you type fast, you can see the
> temp segment in your tablespace with SQL*Plus (segment_name is numbers
> dot numbers, like '9.2' e.g. and segment_type = 'TEMPORARY'). But a
> table you insert a record in before commit is not a temporary segment.

> Yong Huang



> > As are uncommitted table inserts.  Any segment that has not yet been
> > committed is considered temporary.  Essentially the tablespace did
not
> > have enough contiguous space to allocate extent.

> > --
> > David Fitzjarrell
> > Oracle Certified DBA

> Sent via Deja.com
> http://www.deja.com/

A temporary table segment is just that, an extent, if you will, that
has not been committed and is, therefore, 'temporary'.  If 'commit=y'
is not used on import the extents generated are temporarily assisgned
and will not be permanent until the entire table is imported and the
inserts are committed.  A failure to extend a temporary segment is a
failure to allocate a contiguous extent during table creation under imp.

One can see these segments by querying dba_segments during an import --
the temporary extents will be named 'SYS...', similar to an unnamed
constraint.  Once imp issues a 'commit' the names change to that of the
table and the extents are, therefore, permanent.  Until that commit is
issued all extents are temporary and can be rolled back on error.

--
David Fitzjarrell
Oracle Certified DBA

Sent via Deja.com
http://www.deja.com/



Sun, 06 Jul 2003 05:18:36 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

2. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

3. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

4. temp segment in non-temp tablespace??

5. Some question about temp segment

6. Question on Temp Segments

7. Newbie Question on Temp Segments

8. Newbie question on Temp Segments

9. 01652: unable to extend temp segment

10. ORA-1652: unable to extend temp segment by 7680 in tablespace

11. Strange Segment called 6.2 in TEMP

12. Temp segment, info problem.


 
Powered by phpBB® Forum Software