John,
I have been discussing this with a colleague and our question is - what are
you hoping to achieve?
If you are using a spfileSID.ora file then that will be used every time you
startup so in what circumstances would you use the pfile?
PS one suggestion re the problem creating the trigger is
We do essentially the same thing nightly from a dbms
job. Works fine that way. Don't know why yours does
not work. We create the job and run it as sys as
sysdba. Perhaps it is a permissions thingy.
--- John Weatherman [EMAIL PROTECTED]
wrote:
Hi all,
I'm in the process of migrating 8i to 9i