Re: Imp.exe and trigger

In article <p9_c5.1636$k22.4527116_at_nnrp3.proxad.net>,   "Charles Bosquet" <cbosquet_at_free.fr> wrote:
> Hi,
>
> I work with oracle 8.1.5
> When i make a full export of my database, triggers are not
 exported ...
> The command line is 'Exp system/password_at_MaBase full=Y
 file=MyFile.dmp'
>
> Charles BOSQUET APISoft FRANCE,
> Thanks
>
>

I've been doing full exports of my 8.1.5 instances 2 times a week for a while now -- its always gotten the triggers.

what method are you using to see that the "triggers are NOT getting exported?"

If you do an

imp ... full=y show=y

and redirect both stdout and stderr to a log file and then review the log file -- it should show the triggers in there (whereas indexfile=filename.sql will not -- if that is the method you were using to see whats in it...)

that import will not actually import anything, just shows what it would import.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.