Does testtable exist? If not then that's the problem. Does AHVZDIS_DIS_D
exist, if not then that's the problem. Log into sqlplus and do
desc AHVZDIS_DIS_D
and see if it exists
and do
desc testtable
and see if it exists.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Bonnie R" <bonvig_at_aol.com> wrote in message
news:72187104.0302131330.7ecd803c_at_posting.google.com...
> Thanks for your explanations. It's beginning to make more sense to me.
> I've changed my query and now I'm getting a new error, so that must
> progress!
>
> Error:
> ORA-00942: table or view does not exist
>
> Here's my query:
> "insert into testtable select employee_id from AHVZDIS_DIS_D"
>
> I have since given up the idea of downloading the data. I didn't
> realize that Oracle sql was so different from MS sql. In my company,
> someone is already downloading all the oracle tables to a sql server,
> and I'm going to connect to that for my querying.
>
> Thanks for your help!
> Bonnie
Received on Thu Feb 13 2003 - 20:06:25 CST
