Re: two-task error

Spencer,

Thanks for this. I have cleared this issue up. I never mentioned the two task in my .profile env file.

another question:

I need two replicate 4 tables from a remote DB onto my DB. I know there are tools out there (oracle replication) that can do this but is there an easier way. What would you do?? schedule (crontab) a PL/SQL process to run which uploads the tables?

Cheers,
Nick
"Spencer" <spencerp_at_swbell.net> wrote in message news:slHM6.207$ge6.160773_at_nnrp2.sbc.net...
> on HP-UX and Solaris (and other unix as far as i know),
> the environment variable TWO_TASK is used by oracle
> to specify the default database connection string to use
> when connect string is supplied.
>
> e.g.
>
> export TWO_TASK=orcl.mydomain
>
> the tnsnames.ora file (in the network/admin directory)
> should contain an entry for orcl.mydomain, pointing to
> the correct host, port and service_name (8.1+) or sid
> (pre-8.1).
>
> HTH
>
> if you are getting an error message from Oracle, there
> should be an ORA-nnnnn message identifier. please
> provide this error number, and the exact error message
> when requesting assistance.
>
> "Nicholas Mudie" <nmudie_at_chello.com> wrote in message
> news:dUNL6.13722$lC.578161_at_amsnews02.chello.com...
> > Hello,
> >
> > Does anyone know what the two task setting does??
> >
> > I have a CGI script running on one box and have my Oracle install on
> > another.
> >
> > I want to view my Oracle tables using my CGI scripts but it comes back
 with
> > a TWO-TASK error.
> >
> > Does this have something to do with my Oracle environment??
> >
> > Kind regards,
> > Nick
> >
> >
> >
>
>
Received on Fri May 18 2001 - 09:36:59 CDT