Oracle basic concepts and comparison with informix
I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user
The racle database system is a complex software system. Without understanding its internal structure principles and relationships, it is impossible to design and Compile High-Quality application software systems or manage a complex application
Oracle Oracle Product Services and Technology level introduction
Many friends ask the genuine Oracle database products and pirated products are mainly different, in fact, from the product technology itself, the difference is not small, can
Oracle's architecture is broadly divided into two parts: Instance (instance) and database.
Instance (example) : The SGA is mainly included in Oracle Instance and some processes (for example: Pmon, Smon, Dbwn, LGWR, CKPT, etc.). If a user's
Oracle many friends ask genuine Oracle database products and pirated products what is the difference, in fact, from the product technology itself, the difference is not small, you can download a database from the OTN website products, and then
When importing data from IMP in Oracle, hybriddb for MySQL prompts that the character set is inconsistent.
The imp import and exp export functions of Oracle are often used in the production environment for data migration. The character set is
Experiment: A partition data block is corrupted and the partition table data is not fully recoveredBackground: The database does not have a valid backup and a partition has corrupted data blocks.Requirement: Maximum recovery of this partition
Never give up, everything is possible!!!Only to find a way to succeed, not to find excuses for failure!Oracle Connection Summary (internal, external, natural, cross-connect, self-connected) 1. Brief introduction 1) The connection of two tables is
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.