OraFAQ Forum: Server Administration » proble for temptable space growing

Home » RDBMS Server » Server Administration » proble for temptable space growing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

proble for temptable space growing [message #172517]

Wed, 17 May 2006 01:19

deepak samal
Messages: 29
Registered: February 2005

Junior Member

hi ,
i am migrating data from sql server to oracle . it is a very big DB. i am using a database link for migration .
while migrating , the oracle temporary tablespace file size is growing to more than 17 GB. for which i am not able to migrate this bcoz of lack of memory . what could be the problem . is there any solution for increasing in temp table space.

Report message to a moderator

Re: proble for temptable space growing [message #172557 is a reply to message #172517]

Wed, 17 May 2006 03:29

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Just extend the tempfile or add another tempfile to your temporary tablespace:

SQL> SELECT file_name, tablespace_name, bytes FROM dba_temp_files;

FILE_NAME                                TABLESPACE      BYTES
---------------------------------------- ---------- ----------
/app/oracle/oradata/o102/temp01.dbf      TEMP         48234496

SQL> ALTER TABLESPACE temp ADD TEMPFILE '/app/oracle/oradata/o102/temp02.dbf' SIZE 100M;

Tablespace altered.

Report message to a moderator

Previous Topic:	Finding out if a patch is installed
Next Topic:	how to resize tablespace size?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:17:57 CDT 2024