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 -> Re: defragging a tablespace/schema using exp/imp

Re: defragging a tablespace/schema using exp/imp

From: Brian Wheeler <bwheeler_at_us.oracle.com>
Date: Mon, 24 Jan 2000 10:19:20 -0500
Message-ID: <388C6D78.71C26D28@us.oracle.com>

You can export just the schema, drop all the objects owned by the schema,
recreate the tablespace, and then reimport.

--

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

Received on Mon Jan 24 2000 - 09:19:20 CST

This message: [ Message body ]
Next message: Tapan Trivedi: "Re: diff. between Primary-Key and unique index"
Previous message: Gregory Riggs: "ORA-00600 problem with restored backups"
In reply to: Verna Legaspi: "defragging a tablespace/schema using exp/imp"
Next in thread: Frederic Bidon: "RE: defragging a tablespace/schema using exp/imp"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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