Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tablespace cleanup

Tablespace cleanup

From: d1ngo <dont_at_mail.me>
Date: Sun, 4 Mar 2001 15:37:28 -0500
Message-ID: <97u92i$26g$1@bob.news.rcn.net>

Can I do exports of tablespaces? I need to trim the number of datafiles in a tablespace, so I was planning on doing this:

  1. an export of the tablespace
  2. remove the tablespace
  3. create a new tablespace (with one appropriately sized datafile)
  4. import data back into new tablespace

One, I don't even know if this is the best way to do what I'm trying. Two, I can't figure out how to export tablespaces. I've looked at transportable_tablespaces and such, but I must be doing something wrong. If someone's familiar with what I'm trying to do, please help. Thank you. Received on Sun Mar 04 2001 - 14:37:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US