RE: Missing Table

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:ORACLE-L_at_fatcity.com> 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: JayMiller_at_TDWaterhouse.com

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: ListGuru_at_fatcity.com (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).