RE: Missing Table

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. Received on Mon Aug 06 2001 - 07:22:39 CDT