ora 00942

Using the SQL SERVER2005 Export tool, the data export table to Oracle, the table name to see the table, but the query or delete prompt "ORA-00942 table or try not to exist" error, the internet to check a bit, is the following reasons:"When you query or delete a table with a name that doesn't exist, do you see if the table names are lowercase in user_tables?" That means you must have the quotation mark when

;BeginFor rs in C1 LoopDate_o.sun: = Rs. Sun;Date_o.mon: = Rs. Mon;Date_o.tue: = Rs. Tue;Date_o.wed: = Rs. Wed;Date_o.thu: = Rs. Thu;Date_o.fri: = Rs. Fri;Date_o.sat: = Rs. Sat;Pipe row (date_o );End loop;Return;End; Compilation errors for function landuser. get_date_str Error: PL/SQL: ORA-00942: The table or view does not existLine: 46Text: From dba_objects, Solution Connect sys/As sysdba; Grant select on

SQL> conn hr /***SQL> select username, sid, serial #, module, action from v $ session; Select username, sid, serial #, module, action from v $ session ORA-00942: Table or view does not exist Solution: Sqlplus "sys/*** as sysdba"SQL> grant select on gv $ session to hr;Grant select on gv $ session to hr*Row 3 has an error:ORA-02030: only queries from a fixed table/View SQL> grant select on sys. v _ $ session

Tag: Grant Solution: Grant select, insert, update, delete on bookmarks. * to [email protected] identified by 'Password' Authorization statement: Grants the xxx select, insert, update, and delete permissions to the bm_user table. Log on to the system as sys and grant the select and delete SYS. fga_log $ permissions to the system. Otherwise, the following stored procedure may be added. SQL> grant select, delete on SYS. fga_log $ to system; Cause: Later, I found out that if the user has a DB

When imported from PowerDesigner into Oracle, remember to capitalize all the table names in Oracle. In the beginning, because the table name is lowercase and then the default is lowercase in Oracle, there are some very strange cases where the imported table can be seen in the list of all tables in the Enterprise Manager console. and using the table Data Editor, you can also see the imported good data, but in the concrete table space does not even see the table, it is strange, I always think that

Using the SQL SERVER2005 Export tool, the data export table to Oracle, the table name to see the table, but the query or delete prompt "ORA-00942 table or try not to exist" error, the internet to check a bit, is the following reasons:"When you query or delete a table with a name that doesn't exist, do you see if the table names are lowercase in user_tables?" That means you must have the quotation mark when

')))Group BY Date_w;BeginFor RS in C1 loopDate_o.sun: = Rs.sun;Date_o.mon: = Rs.mon;Date_o.tue: = Rs.tue;date_o.wed: = rs.wed;Date_o.thu: = Rs.thu;Date_o.fri: = Rs.fri;Date_o.sat: = Rs.sat;Pipe row (date_o);End Loop;ReturnEnd Compilation errors for FUNCTION Landuser. Get_date_str error:pl/sql:ora-00942: Table or view does not existline:46Text:from Dba_objects A, Solutions Connect Sys/as sysdba; Grant SELECT on Dba_objects to Landuser; SELECT * FRO

You can directly query the jytest1.test table under jytest, but create a process under jytest. During the process, the jytest1.test table is referenced and cannot be compiled. You can directly query the jytest1.test table under jytest, but create a

Later, I found out that if the user has a dba role, the permissions contained in the role will not be inherited in the stored procedure. Therefore, I separately added the permissions for tb_bil_acct_566, seq_bil_acct_his _ Later, I found out that if

Two users, jytest and jytest1, both have dba permissions. In jytest1, a user creates a table named test. Create user jytest identified by "jytest" Default tablespace users temporary tablespace temp;   Grant dba to jytest; Grant resource to

Production environment, due to the previous database failure, resulting in a few days of downtime, the operator asked to save a backup, 2016-09-05 with EXPDP export process problems ora-39006:ora-39065:ora-04063:ora-06508:ora-39097:ora