I had a similar really weird problem on a pl/sql program - it compiled
successfully on 8.1.6 but failed on 8.0.4 saying the table didn't exist.
After trying a bunch of stuff I qualified the table name with the schema
(i.e., schema.table_name instead of table_name). This shouldn't have made
any difference since I was logged in as the table owner but the program
compiled! I have a note on my calendar to remove the schema name from the
program after my upgrade...
Try specifying the the schema owner in the sql loader script and see if it
makes a difference.
Jay Miller
-----Original Message-----
Sent: Monday, August 06, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L
The way they log in, they are the owner of the tables.
It gets flakier. I have since found out that three of our incrementally
updated clients (reporting environment) have similar problems with tables.
One has only one table, different from these two... a second has one table
(witness_info) and this client with two tables. The programs accessing
these tables is the same program, with userid and password furnished by a
driver file with tablespace into, userid password and instance. The three
span two different instance, three different schemas.
-----Original Message-----
Sent: Friday, August 03, 2001 5:45 PM
To: Multiple recipients of list ORACLE-L
April:
Does the user this programs logs in as explicitly have SELECT rights against
the table? If the rights are acquired through roles only, maybe they need to
be explicitly granted.
Are you sure it's selecting the table, if it's not in that user's schema and
not accessible via synonym, with a fully qualified owner.table_name?
Just my ideas?
Jon Walthour
----- Original Message -----
To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L
Sent: Friday, August 03, 2001 4:29 PM
Okay guys, this is stumping me and one of our programmers.
We have tables witness_info and agent_info in a schema on one of our big
instances. We run sql*loader loads every night driven by a C program that
calls gathers up the userid, password and instance name of the given schema
from a flat file, and a parameter file from a different directory on our AIX
box and the control file from yet another directory. We load a dozen tables
just fine, hit the agent_info table and sql*loader can't find it. The table
before in the parameter file it finds, agent_info Table not found. Goes on
to load another 4 or 5 tables (I can see it in the nohup file) then...
witness_info... table not found. Then it continues with the load
successfully. The table earlier in the processing had a batch delete run
against it successfully. I can insert with SQLplus successfully, I can desc
the table, I can delete the row I inserted successfully, I can load the
data successfully with command line sql loader.
Any ideas on what I'm missing in this flaky scenario??
April
The information contained in this e-mail is strictly confidential and for
the intended use of the addressee only; it may also be legally privileged
and/or price sensitive. Notice is hereby given that any disclosure, use or
copying of the information by anyone other than the intended recipient is
prohibited and may be illegal. If you have received this message in error,
please notify the sender immediately by return e-mail.
Corporate Systems, Inc. has taken every reasonable precaution to ensure that
any attachment to this e-mail has been swept for viruses. We accept no
liability for any damage sustained as a result of software viruses and
advise you carry out your own virus checks before opening any attachment.
_____
Okay guys, this is stumping me and one of our programmers.
We have tables witness_info and agent_info in a schema on one of our big
instances. We run sql*loader loads every night driven by a C program that
calls gathers up the userid, password and instance name of the given schema
from a flat file, and a parameter file from a different directory on our AIX
box and the control file from yet another directory. We load a dozen tables
just fine, hit the agent_info table and sql*loader can't find it. The table
before in the parameter file it finds, agent_info Table not found. Goes on
to load another 4 or 5 tables (I can see it in the nohup file) then...
witness_info... table not found. Then it continues with the load
successfully. The table earlier in the processing had a batch delete run
against it successfully. I can insert with SQLplus successfully, I can desc
the table, I can delete the row I inserted successfully, I can load the
data successfully with command line sql loader.
Any ideas on what I'm missing in this flaky scenario??
April
The information contained in this e-mail is strictly confidential and for
the intended use of the addressee only; it may also be legally privileged
and/or price sensitive. Notice is hereby given that any disclosure, use or
copying of the information by anyone other than the intended recipient is
prohibited and may be illegal. If you have received this message in error,
please notify the sender immediately by return e-mail.
Corporate Systems, Inc. has taken every reasonable precaution to ensure that
any attachment to this e-mail has been swept for viruses. We accept no
liability for any damage sustained as a result of software viruses and
advise you carry out your own virus checks before opening any attachment.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
