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: Refreshing test d/base

Re: Refreshing test d/base

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Apr 2005 06:54:33 +0200
Message-ID: <frtr511g10m8r8ehdt68l60etu0a3vqgf9@4ax.com>


On 13 Apr 2005 19:12:57 -0700, "Vsevolod Afanassiev" <vafanassiev_at_yahoo.com> wrote:

>
>Eugene,
>
>So you want to refresh the data (table rows) but keep stored PL/SQL
>procedures? If the database is small you can use Export/Import:
>- disable constraints
>- truncate tables
>- import data
>- re-enable constraints

You can't suppress the export of PL/SQL.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Apr 13 2005 - 23:54:33 CDT

Original text of this message

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