This discussion is archived
13 Replies Latest reply: Nov 13, 2012 1:16 PM by jgarry RSS

oracle 9i database full while inserting lines

973850 Newbie
Currently Being Moderated
Hi,
i wanna copy data from a table to another one (same structure, only difference is that the second table is partitioned).
the origin table consists of about millions of lines
so i made an insert : insert into table2 select * from table1.
the insertion doesn't end correctly : TOAD crashes, any line was inserted in table2 : select * from ...etc. However, the file system becomes full.
i would if there is a way to purge something like cache ..., are these lines inserted somewhere : temporary table..., so i can reduce filesystem size.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points