|ORA-00942:||table or view does not exist|
|Cause:||The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.|
|Action:||Check each of the following:|
- the spelling of the table or view name.
- that a view is not specified where a table is required.
- that an existing table or view name exists.
Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.
Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.
|Posts about ORA-00942|
Can you help me with this?
SQL > select open_mode from v$database
SQL > show user
USER is "SYS "
SQL > select table_name from dictionary where table_name likHi all
I have noticed that something that I was able to do in oracle9 can 't be
done in oracle10. This is very annoying and
I would appreciate any thoughts on this
SQL > select * from v$vHi all I 'm working with sql stored procedure and I created these one
CREATE OR REPLACE PROCEDURE today (tbl_name IN VARCHAR2 old_key IN NUMBER) AS
SELECT COUNT(*) INTO l
I would suggest a modified UNION-ALL version (a solution I have myself used
on occasion (3VL may - as always - bite you though))
SQL > select * from v$version
On 04/12/2006 11 25 50 AM Simone Saravalli wrote
> hi to everybody
> I use Oracle 10g Express and I 'm dealing with the connection to the
> database in php through the use of pear. In order to c Hello
I have a general issue with loading data into a Oracle 220.127.116.11 database on
solaris 8. I reduced it down to a simple statement which takes 1 second on
my PC (oracle 18.104.22.168) but takes 20 secoHi all
I 've been reading this guide / that guide trying to get this problem fixed
but have failed -( So I 've created a simple example to illustrate my error
(lack of knowledge).
My master tabl
On my Oracle 8.1.7 & 9.2 databases -
SQL > SELECT * FROM V$TRANSPORTABLE_PLATFORM Failing with the Error -
SELECT * FROM V$TRANSPORTABLE_PLATFORM
ERROR at line 1
ORA-00942 table Frank
If you code the table name in the package it will simply not
compile. The only thing you can do IMHO is to use dynamic SQL and trap
http A colleague is trying to create a logical standby database. During apply it
is getting stuck on
LOGSTDBY stmt grant select insert on sys.ora_temp_1_ds_24148 to "SYSTEM "
LOGSTDBY status ORA-00942Solaris 9 Oracle 22.214.171.124
Hi! I 'm trying to grab a process id from the database and store it in
a variable. This syntax works if I 'm not using a v$ view. If I use a
v$ view it ignores what 's afterHi list oracle 126.96.36.199.0 SunOS 5.8 sun4u sparc SUNW Sun-Fire
this is making me crazy I have 2 directories created
CREATE OR REPLACE DIRECTORY "DIR_NB " AS
'With 10g worry nomore
Just find out this feature today...
I help administer a 188.8.131.52 database which is exported each night. The ful
export process always receives the error below related to
Could someone please tell me what is wrong here? 20
alter table dwo.part_tab split partition P20050601 at (TO_DATE( '
2005-05-11 00 00 00 ' 'SYYYY-MM-DD HH24 MI SS '
'NLS_CALENDAR 3DGREGORIAN ')) On Thu 3 Mar 2005 12 49 24 -0400 Juan Carlos Reyes Pacheco
<juancarlosreyesp@(protected) > wrote
> Hi carmen move to a tablespace and make it read only.
what like this? read only doesn 't necessHi All
Firstly I have changed my Display name from New DBA
to my original name. The reason I kept it as New DBA
was to highlight the fact that I was just a novice and
be treated likewise -)
" If the DBLink is created without a identified by the user must
provide a 20
Password each time it is used. "
Not true IF the user id exists on both servers (with of course the same
password).I have Oracle 9.2.04 running on Win2K Box with one database ID05 on it .I
have created one more database redi on same machine . I am trying to take
full export of redi
database i am getting folOne of my frnd is trying to generate development DB from production.
Production machine is 8.1.7 and development DB where he want to upload
a DB is 9.2. He is taking export from his machine n gettare there by chance materialized view logs on these tables? did you by
chance migrate via import/export?
<preface - this is pre-coffee >
I 've been fighting an issue which has me baffled. Basically i
performed a database upgrade of Oracle on Solaris 8 migrating 3
instances from 9i to 10g. EveryHi!
> What is the largest number of user sessions *
> datafiles filesystem handles that you 've encountered
> in win32 land?
Hm strange I always thought that due the single-process architecHi
Am Di den 13.07.2004 schrieb Anton Dischner um 10 36
> please take this for a very basic benchmark in SQL*Plus
> please share your results
at first i would like to thank you aSQL*Plus is probably passing 942 out as the return code. However unix can handle values from 0 to 255. Any return code in excess of 255 is returned as the modulus of
SQL > seleAs Daniel pointed out yesterday the Exit line can only accept up to 256.
After that it uses the Mod of the number and 256. 942 Mod 256 is 174.
Hence the reason you are getting 174 back.
Is there any way to pass both the SQL.SQLCODE & SQLERRM to the os back ??
When I tried WHENEVER SQLERROR EXIT SQL.SQLCODE
The actual oracle error code (ORAI did not know that. Thats for this info as well as the rollback info.
From Daniel Fink [mailto Daniel.Fink@(protected)]
Sent Tuesday July 20 2004 1 12 PM
Kevin Lange wrote
> The thing is the ?$ will not give you anthing but a 0 when you use it after
> the SQL statement because SQLPLUS finish correctly ... even if the SQL that
> is ran doUnfortunately error messages related to replication in version 8.0 hardly
ever told it all )
Several years ago we were getting an ORA-00942 on a simple
replication/snapshot setup the reason Got this simple proc
SQL > create or replace procedure dave_test (p_user_id IN varchar2) as
1 ' TRUE)
I am trying to configure TG4DRDA to connect to
AS400/DB2 system. When I am trying to bind the package
GTW$_BIND_PKG I am getting the error
********************* ERROR START *********We have a production oltp that has logs build on tables necessary to
reporting so that we and replicate them to the reporting database. I am
trying to set up a valid test environment with exp/imp. |
|Oracle Database Server Error Codes|