Did you export with compress = N?

-----Original Message-----
From: Michael Fanara [mailto:michael.[Email Address Removed] Tuesday, April 30, 2002 12:58 PM
To: LazyDBA.com Discussion
Subject: recover table space


DBAs,

In one of my instances I truncated all tables with the drop storage clause
that a user owned. It totaled about 335MB. What I wanted to do was use and
import from another Instance that has fresh data to repopulate the deleted
tables.

When I imported the data, i received errors pertaining to out of tablespace
errors. The tablespace is 500MB, but I thought when I truncated the tables
I would regain the 335MB and start from scratch.

Do I need to drop all tables in the schema to recover the space and then to
a reimport creating the table?

Thnx.





Mike Fanara
Network Administrator/Webmaster
Office of Facilities
Yale University
203-432-4719 w
203-432-8881 f
203-627-1773 c


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


*==============================*
Any views expressed in this communication are those of the individual
sender, except where expressly identified as the views of the Fundtech
Corporation. This message contains confidential information of the sender
or Fundtech as applicable and is intended only for the individual named. You
may not disseminate or distribute this message. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
immediately delete this e-mail from your system. E-mail transmission cannot
be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. Neither the sender nor Fundtech accept liability for any
errors or omissions in the contents of this message which arise as a result
of e-mail transmission.
*==============================*
Oracle LazyDBA home page