Home » RDBMS Server » Server Utilities » Help! I killed an Oracle 8.1.7 import...
Help! I killed an Oracle 8.1.7 import... [message #124203] Thu, 16 June 2005 17:43 Go to next message
dk11
Messages: 2
Registered: June 2005
Junior Member
on purpose because it was taking too long. This is on a test machine, and was not responding to CTL-C. I brought Oracle back down, then restarted. Everything in the restart log looks fine. I then did a 'truncate table' to get rid of any imported data. The command just hung, but all data was gone. An associate and I added some data, did a delete - no problem. We entered a new 'truncate table' command a few hours ago on the table with zero records, and it is using up time.

Any suggestions would be greatly appreciated - something is definitely wrong. Thanks in advance.

Report message to a moderator

Re: Help! I killed an Oracle 8.1.7 import... [message #124208 is a reply to message #124203] Thu, 16 June 2005 19:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is this a dictionary managed tablespace?
Seems there is a lot of extents allocated.
Truncate resets HWM and frees the used extents. If there are too many extents involved, it would be busy updating UET$ and FET$.

did you try
sql> truncate table Mytable reuse storage;

Report message to a moderator

icon14.gif  Re: Help! I killed an Oracle 8.1.7 import... [message #124211 is a reply to message #124208] Thu, 16 June 2005 19:41 Go to previous message
dk11
Messages: 2
Registered: June 2005
Junior Member
It worked! Thank you.

Report message to a moderator

Previous Topic: export unsucessfull - ora-24389
Next Topic: creating control file to load data from a text file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 05:59:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.