I. Oracle Data Dictionary
A data dictionary is a place where Oracle stores database information. It is used to describe data. For example, the Creator information, creation time informa
Oracle Data dictionary is the most important component of Oracle Database. It is the place where Oracle stores information about the database. It is used to describe data and provides the system information of the database, and in
1.1 symptom description
UseExpAn error occurred while exporting data. The following error message is displayed:
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please sort y your DBA
EXP-00000: Export terminated unsuccessfully1.2 possible causes
After the database is upgraded, the data
Label:First, the conceptThe data dictionary is the most important part of the Oracle database, and it provides some system information about the database.The dynamic performance View records information about the startup of the routine. Second, the data dictionary1), the data
modified by users. They can only be viewed and used. Data dictionaries also have basic dictionary tables that cannot be further divided. Others are mainly views, views, and synonyms, however, we can only use these views, view views, and synonyms.Why don't you let me see the basic table in Oracle "? Let you see, do you
The following articles mainly describe Oracle Data Dictionary documents, it is worth noting that the correct application of Oracle data dictionary and actual operations and specific operations in actual operations are the main con
I. Oracle DATA dictionaryA data dictionary is where Oracle stores information about a database and uses it to describe the data. For example, the creator information of a table, create time information, the table space information
Oracle uses data dictionaries to manage and display database information. data dictionaries usually store database metadata such as ldquo and rdquo ;. Data words
Oracle uses data dictionaries to manage and display database informa
Oracle Data Dictionary OverviewDatabase is a collection of data, database maintenance and management of this user's data, then where the user data tables, the user's information, where
Oracle Database-related data dictionary for performance problem analysis, oracle-related data
The nine most important dynamic performance views of oracle!
V $ session + v $ session_wait
V $ process
V $ SQL
V $ sqltext
V $ b
Data dictionaryFirst, what is a data dictionaryA data dictionary is a collection of tables and views that Oracle stores all instance information. The Oracle process is in the SYS modeMa
current user can access instead of the current user. For Dba_ to start with administrator privileges, other uses are exactly the same, here is not to repeat. 2. Dynamic Data dictionary Oracle contains a number of potential tables and views that are maintained by system administrators such as SYS, which are called Dyna
oracle| Data | Application Example
Introduction to Oracle Database Dictionaries
Oracle data dictionaries consist of tables and views that store some database objects about database structure information. The database
Oracle Data Dictionary
Oracle uses data dictionaries to manage and display database information. data dictionaries usually store database metadata, which is the "Database" of databases ". Generally, a
The ORACLE tutorial is a brief analysis of Oracle Data dictionary technology.
A data dictionary is a place where Oracle stores database information. It is used to describe
Label:Each database provides a schema for its own data dictionary, albeit in a different form, but with the same purpose and function as in MySQL, where the data dictionary is represented in Information_schema, and SQL Server is shown in the SYS system schema.Oracle's data
select * from dictionary;
--Data dictionary
The data dictionary is where Oracle holds information about the database tutorial, and its purpose is to describe the data.
For example, a
Oracle Data Dictionary Overview
Data dictionary is an important component of Oracle databases. It is a set of read-only tables used to record database information.
The
Select * from dictionary;
-- Data Dictionary
A data dictionary is a place where Oracle stores database information. It is used to describe data.
For example, the Creator information, cr
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.