Guide: SynonymIt is an alias for database solution objects and is often used to simplify object access and improve object access security. When using synonyms,Oracle DatabaseTranslate it into the name of the corresponding solution object. Similar to
Oracle Database provides the synonym management function. Synonyms are aliases of database solution objects. They are often used to simplify object access and improve object access security.
Oracle Database provides the synonym management function.
When a new feature of Oracel comes out, we may not know all the data dictionary names associated with this feature,So how do you get meta data for these meta data?Can be viewed through Dicitonary:For example, find a list of data dictionary names
Oracle Database provides the synonym management function. Oracle synonyms are aliases of database solution objects. They are often used to simplify object access and improve object access security. In Oracle databases, most database objects, such as
The Oracle database provides the synonym management function for the creation of Oracle synonyms. Oracle synonyms are aliases of database solution objects. They are often used to simplify object access and improve object access security. In Oracle
1
The following table between database objects that can be migrated when migrating from another database to PPAs
2
Installation of PPAs will have the option to install Migreation Toolkit, you can choose to install, you can also download the
The relevant knowledge points of this content we introduced some of them when we studied sqlserver2008r2, including: Transactions, indexes, views, etc. So today we are learning to implement these important things on Oracle for database
Today, let's take a look at how to manage database objects in the orcale database.
I. Synonyms
1. Solution
The solution is a collection of database objects. The solution contains various objects (tables, views, indexes, synonyms, sequences,
1. Transaction: A logical unit consisting of a set of commands that ensures that all operations either succeed or all fail.End of transaction: 1) Explicit commit (Commit) 2) explicit rollback (rollback) 3) DDL statement Stealth commit 4) normal End
ORA-00001: violation of unique constraints (.) ORA-00017: Request session to set trace event ORA-00018: exceeds Max sessions ORA-00019: exceeds Max session licenses ORA-00020: exceeds Max processes () ORA-00021: Session is attached to some other
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.