ora 00942

The error is as follows:Search a lot of methods, but there is no way to solve, but eventually found a good solution,Thanks to the man's blog, "http://blog.itpub.net/519536/viewspace-689469."The content is purely reproduced, suggest to the original blog to see the detailsProcessing methodsNow that you know what caused the user to fail to delete, the table sdo_geom_metadata_table was not found. The way to deal with it is to find it.We can consider using the Catmd.sql script to re-initialize the ta

Various objects (including tables, columns, and indexes) in Oracle databases are case-insensitive by default. All objects in the data dictionary are in uppercase. Assume that when you create a table (including an external table ), Various objects (including tables, columns, and indexes) in Oracle databases are case-insensitive by default. All objects in the data dictionary are in uppercase. Assume that when you create a table (including an external table ), Various objects (including tabl

Various objects (including tables, columns, and indexes) in Oracle databases are case-insensitive by default. All objects in the data dictionary are in uppercase. If you enclose the column name or table name in double quotation marks when creating a table (including external tables), these are case-sensitive database objects. At this time, select needs to strictly follow the case when the table is created to succeed, otherwise return ORA-000904 or

tables/viewsSQL> conn gx_adm/xxx --> use the gx_adm user to connect to the Database Error accessing PRODUCT_USER_PROFILEWarning: Product user profile informa Tion not loaded! You may need to run PUPBLD. SQL as SYSTEMConnected. -- the user can access the dynamic performance view of SQL> select username FROM v $ process WHERE ROWNUM 3. Metalink article (Doc ID 1062335.6)ORA-942 when select from any v $ view within stored PL/SQL procedure (Doc ID 10623

In the Oracle 10 Gb database, a materialized view is modified with a simple condition clause, deleted and rebuilt, but the creation fails, reporting that the ORA-00942 table or view does not exist. This is a strange question. Do I think this is a bug first? I found metalink of oracle and found similar bugs, but the solution is not suitable. So I analyzed and solved it myself, and found a pitfall followed by

A ORA-00942: The table or view does not exist error occurred when I was using PLSQLDeveloper to delete a table shortly after I got in touch with Oracle. Someone on the Internet said that ca was added after the SQL statement. A ORA-00942: The table or view does not exist error occurred today when I was using PL/SQL Dev

Using Oracle database, using powerdesigner design, generate SQL File Import query appears "ORA-00942: Table or view does not exist", very depressed, this problem has appeared before, originally solved, however, because I haven't used it for a long time, I forgot it this time, which makes me waste some time. To avoid forgetting it again, write it down and share it with everyone. 1. cause of the problem Oracl

In the process of learning "spring boot", because the original book author inevitably have some missing places, or system, software version inconsistency, framework updates and other factors, the full installation of the source page in the book can not achieve the normal start of the projectIn chapter 8.2, when the JPA support for Oracle is demonstrated, the following code is set in the configuration file, which normally should support the database to automatically create the sequence and table,

colleagues can query the data in the table, but when truncate this table hold ORA-00942: The table or view does not exist The beginning thought is the table name writes has the question, but later discovered that he deletes is not the table, but is a synonym (synonym) It is not possible to use truncat for synonyms synonym. Connected to Oracle Database 11g Enterprise Edition release 11.2.0.1.0Connected as

tables/viewsSQL> conn gx_adm/xxx --> use the gx_adm user to connect to the Database Error accessing PRODUCT_USER_PROFILEWarning: Product user profile informa Tion not loaded! You may need to run PUPBLD. SQL as SYSTEMConnected. -- the user can access the dynamic performance view of SQL> select username FROM v $ process WHERE ROWNUM ORA-00942: table or view does not exist Solution Description: Grant the own

This article to give you a detailed introduction to ORACLE prompt ora-00942 table or view does not have a solution to touch such a problem of friends can go to the reference. This article to give you a detailed introduction to ORACLE prompt ora-00942 table or view does not have a solution to touch such a problem of fr

ORA-00942: table or view does not exist 　　 Cause: this is because the mounted table or view does not exist. Most of the reason is that CATEXP. SQL is not running and the Export view cannot be executed. If CATEXP. SQL is already running, it may be a version error. 　　 Solution: because some views shared by Import and Export run CATEXP. SQL to load (they have the same view) and do not generate a separate CATEX

Depressing: powerdesigner generates the Oracle table creation script, but the generated table cannot be inserted, exp, update, drop reports ORA-00942: Table or try not to have an exception, I thought it was caused by Oracle configuration. I found a lot of posts online! Deleted users in all ways ...... Drop user lizhiyu cascade; Improper: Use the Oracle table creation script generated by powerdesigner to

Now do a project that was previously connected to someone else's machine data, and then I'm going to import the data into the local database and run the error, as follows:Hibernate:select sum (rdb_alert_0_. Event_count) as col_0_0_ from Eapsoft. New_topices rdb_alert_0_-SQL error:942, sqlstate:42000-ORA-00942: Table or view does not exist It is also an error to run the SQL statement in the Plsql develop, "

Tags: ora-00942After Oracle creates a new user, the client executes the SQL query with the following error message:Execute the query statement as follows:SELECT * from Sm_sales_order;ORA-00942: Table or view does not existCreate a new user and specify tablespace and temp table spaceCREATE USER xxx identified by xxxxDEFAULT tablespace LMSTemporary tablespace TEMP;

Tags: des style blog color use AR for file data Using Oracle database, using powerdesigner design, generate SQL File Import query appears "ORA-00942: Table or view does not exist", very depressed, this problem has appeared before, originally solved, however, because I haven't used it for a long time, I forgot it this time, which makes me waste some time. To avoid forgetting it again, write it down and shar

Transferred from: Larry. Yue's Http://miracle.blog.51cto.com/255044/93450 Copyright: Original Works are allowed to be reproduced. During reprinting, be sure to mark them as hyperlinks. Original Article Source , Author information and this statement. Otherwise, legal liability will be held. Http://miracle.blog.51cto.com/255044/93450 For PL/SQL objects such as the process, function, or package of writing database monitoring or writingPerformance view) and data dictionary, the following errors are

Today, while writing the stored procedure, I found a very strange problem, stored in the process of a simple select dynamic SQL statement. After writing, execute this stored procedure, always prompt ora-00942:table or view does not exist (ERROR-942 ORA-00942: The table or view does not exist) this error, but I copy thi