EXP/IMP data migration recently, all data of a user in a small database needs to be migrated to another one. Now, we first simulate that the data volume is not large, use exp to export all data objects of the User: [SQL] [lubinsu @ localhost orcl] $ exp lubinsu/lubinsu @ orcl_03 file =/home/lubinsu/orcl/lubinsu. dmp log =/home/lubinsu/orcl/lubinsu. log owner = lubinsu compress = n Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production With the Partitioning, OLAP and D
impossible to completely avoid conflicts. Therefore, you can only minimize conflicts when designing H. At the same time, you also need to determine how to solve the conflict so that the conflicting synonyms can be stored in the table.
(4) Factors Affecting the conflictIn addition to H, the frequency of conflicts is also related to the extent to which tables are filled.Set M and N to indicate the number of completion points of the table length and tab
|> M, No matter how H is designed, it is impossible to completely avoid conflicts. Therefore, you can only minimize conflicts when designing H. At the same time, you also need to determine how to solve the conflict so that the conflicting synonyms can be stored in the table.
(4) Factors Affecting the conflictIn addition to H, the frequency of conflicts is also related to the extent to which tables are filled.Set M and N to indicate the number of comp
Oracle view and other object operationsView and other object operations
Lab Purpose
(1) master the creation, query, modification, and deletion operations of views.
(2) establish, query, modify, and delete synonyms, and compare the operations on synonyms with those on the original database objects.
(3) Establish, query, modify, and delete sequences, and insert data into database tables using sequences.
Lab c
not supported. Bitmap indexes can be simple (single-column) or connected (multiple columns), but most of them are simple in practice. Bitmap indexes are best used for low to medium cluster (cardinality) columns on which multiple bitmap indexes can be used in conjunction with and OR operators. Bitmap indexes use bitmaps as key values, and each data row bitmap in a table contains True (1), FALSE (0), or null values. Bitmap indexes are stored in the page nodes of the b-tree structure. The B-tree s
Oracle's data dictionary, which Oracle translates as the name of the corresponding object when using synonyms.1. Use of synonyms1) Simplifying SQL statementsIf the user creates a table with a long name, you can create an Oracle synonym for the table to simplify the statement.2) Hide the name and owner of the objectIn multi-user collaborative development, the names and holders of objects can be masked. If you do not have
], K2 = K5, but h (K2) = H (K5), so the storage address of K2 and K5 is the same.
(2) conditions for preventing security conflictsThe best way to resolve conflicts is to avoid conflicts. To achieve this, two conditions must be met:① One is | u | ≤ m② The second is to select an appropriate hash function.This only applies to scenarios where | u | is small and the keywords are known in advance. At this time, the hashed function H is carefully designed to completely avoid conflicts.
(3) conflicts ca
, and row-level locking is not supported. Bitmap indexes can be simple (single-column) or connected (multiple columns), but most of them are simple in practice. Bitmap indexes are best used for low to medium cluster (cardinality) columns on which multiple bitmap indexes can be used in conjunction with and OR operators. Bitmap indexes use bitmaps as key values, and each data row bitmap in a table contains True (1), FALSE (0), or null values. Bitmap indexes are stored in the page nodes of the b-tr
Edition release 10.2.0.3.0-64bit Production
With the partitioning, real application clusters, OLAP and Data Mining options exported ZHS16GBK character set and Al16utf16 NCHAR character set
. Exporting Pre-schema process objects and actions
. Exporting external function library names for user Zhejiang
. Export public type synonyms
. Exporting private type synonyms
. Exporting object type definition fo
extracting synonyms based on a user-supplied list of custom synonyms that convert the related word to a synonym.A full-text index is generated by segmenting the text data in the user table (Word breaker) and extracting stemming (stemmer), converting synonyms (thesaurus), filtering out the stop words (Stopword) in the word breaker, and finally storing the process
REPLACE VIEW empv20 as SELECT * from EMP WHERE deptno=20 with READ only; Synonyms Synonyms are public and private, and creating the appropriate permissions is required Grant Create [public] synonym to user name Sql> SELECT sysdate from dual; Dual is a virtual table that is defined under the SYS user and can be queried using the following statement Sql> SELECT * from tab WHERE tname= ' DUAL '; This table
Tags: oracle note Li Xinghua
Disable the user login password
user Scott Current login password is invalid, note requires DBA users to operateSql>alter USER Scott PASSWORD EXPIRE;Description: After the above statement operation,when the Scott user logs back in, the database prompts for a new login password
Synonyms
1 . Synonyms are an alias for database schema objects and are of
. When several small databases are integrated into a large database and serve a wide range of organizations, if the database stores historical data, it provides decision-making support, data aggregation, and read-only data, in essence, it acts as a data receiver for all the finished databases that provide data to it. Therefore, it is usually called a data warehouse.
Instance)
It is a part of the computer memory required to access the Oracle database and assists in processing background processes
The following table collects almost all views or aliases in the Oracle Data Dictionary. Use the 'describe' statement to query the fields of each view or Alias. Description: In the Oracle Data dictionary, the object names are mostly "user. "," All. "," DBA. "prefix" user. "The view records the information of the objects owned by the account that normally performs the query," All. "view records include" user "records and information of objects authorized to public or users," DBA. "The view contain
location is given by the user_dump_dest parameter. For example, the parameter file initora8.ora provides:
# Define directories to store trace and alert files
Background_dump_dest = D:/Oracle/admin/ora8/bdump
User_dump_dest = D:/Oracle/admin/ora8/udump
The background trace file is named sidproc. TRC.
§ 2. 13 ORACLE System Data Dictionary
Data dictionary is the knowledge base for all objects stored in the database. The Oracle database system uses the data dictionary to obtain object information a
Google provides synonym search results to try natural language understanding Technology
Google's official blog today claims that it has used natural language understanding technology to identify synonyms in search. For example, Google search considers "pictures" and "Photos" to be the same in a certain context, taking the Query [pictures developed with coffee] as an example, we can see that the "Photos" in the search results has been bold. This is a
results, it should be easy to understand, when they only worship you. Well, little handsome handsome happy point, a wall is normal, as long as in here to learn from the lesson is good.
Small handsome, although still a bit unhappy in the heart, but did not just start so angry. Small handsome answer: OK, I will continue to do function first, I first try to do the function of synonyms.
Examples of synonyms:
1
, processes, functions, packages, synonyms(I will explain in detail some of these unfamiliar concepts below)
Therefore, we need to establish a database in Oracle that is similar to ms SQL: general process· Create a data table space (equivalent to the data file of the ms SQL database)· Create a temporary tablespace (equivalent to the transaction log file of the ms SQL database)· Create a user, but save the tablespace and temporary tablespace as the new
The following table collects almost all views or aliases in the Oracle Data Dictionary. Use the 'describe' statement to query the fields of each view or Alias. Description: In the Oracle Data dictionary, the object names are mostly "USER. "," ALL. "," DBA. "prefix" USER. "The view records the information of the objects owned by the account that normally performs the query," ALL. "view records include" USER "records and information of objects authorized to PUBLIC or users," DBA. "The view contain
priority.The precision, decimal places, and length of the result depend on the precision, decimal places, and length of the input expression. For more information, see precision, decimal places, and length.SQL Server provides a synonym for data types for SQL-92 compatibility. For more information, see Data Type synonyms. Fcpw ~ O ^G [1 $ nwww.tzsy.cnExact numberIntegerInt, bigint, smallint, and tinyintUse the exact numeric data type of integer data.B
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.