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: How Do I compact Oracle Database ?

Re: How Do I compact Oracle Database ?

From: Horace Chow <horacecw_at_netvigator.com>
Date: Fri, 30 Oct 1998 18:03:26 +0800
Message-ID: <36398EEC.83ECEACC@netvigator.com>

Try it :

Export the table(s) by exp
Drop the table(s) or truncate the table(s)
Import the table by imp

Hope this can help you.

Horace Received on Fri Oct 30 1998 - 04:03:26 CST

This message: [ Message body ]
Next message: Dean Cunningham: "DB block buffers and Shared Pool Size on Oracle 7.3 Windows NT 4.0"
Previous message: Ken Roth: "Oracle/Linux kernel tuning"
In reply to: Choong Chee Tuan: "How Do I compact Oracle Database ?"

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