Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Refreshing test d/base
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 DBAReceived on Wed Apr 13 2005 - 23:54:33 CDT