Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions.
This article describes the support of the data pump version.
In 11.2, Oracle added functionality to the version, and the data pump also supports exporting to the specified version or importing the object into the specified version.
Sql> Conn YANGTK/YANGTK
is connected.
Sql> Select Sys_context (' USERENV ', ' Current_editio
Database objects
Common: tables: basic database objects for storing data, composed of rows (records) and columns (fields)
Constraints: series of rules for performing data verification to ensure data integrity
View: Logical display of data in a table
Index: an index is created based on the specified fields in the table to improve query performance.
Sequence: a set of regular integer values
Synonym: alias of an object
Name: it must start with a letter.
Lucene implements index creation and retrieval; Ikanalyzer realizes the Chinese word segmentation, the light has been able to achieve the Chinese search, but the light is not enough, many projects in the search, should also be able to deal with synonyms, such as the index library has "computer", "computer" such as the entry, search "Notebook" should also be able to "computer", "computer" such an entry to match, which involves the index of the synonym
synonym for ease of use:Create synonym worker_syn FOR worker @ zrhs_link;You can also create a local remote view for ease of use:Create view worker as select * FROM worker @ zrhs_link where... ;Now this view can be treated like any other view in the local database, and can be authorized to other users to access this view, but this user must have the permission to access the database link.In another case, t
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
synonym
Work_city public synonym
Plant_detail public synonym
Jill sal_limit private synonym
Work_city public synonym
Plant_detail table owner
Consider whether the following SQL statements can be shared between the two users.
Can SQL be shared?
Select max (sal_cap) from sal_
, ORACLE only provides high-speed buffer (cache buffering) for simple tables. This function is not applicable to multi-table join queries.
The database administrator must set appropriate parameters for this region in init. ora. When the memory area is larger, more statements can be reserved. Of course, the possibility of sharing is higher.
When you submit an SQL statement to ORACLE, ORACLE will first find the same statement in the memory.
It should be noted that ORACLE adopts a strict match betw
(record_id number (6, 0), record_text varchar2 (10); insert into St values (test_seq.nextval, 'aaa'); insert into St values (test_seq.nextval, 'bbbbb'); insert into St values (test_seq.nextval, 'ccccs'); insert into St values (test_seq.nextval, 'ddddd'); select * from St;
C) Modify the existing Sequence
Alter SequenceSequence_name
[Option];
Alter sequence test_seq increment by 2; select region from dual; select test_seq.nextval from dual; insret into st (Region, 'eee'); insret into st
Oracle study notes 9 database objects, oracle Study NotesOracle database objects are also called schema objects. database objects are a set of logical structures, and the most basic database objects are tables. Other database objects include: synonym is an alias of an existing object. It has the following functions: 1. Simplified SQL statement 2. Hiding the Object Name and owner (hiding the original object content) 3. There are two types of public acc
Tags: out left and right comm brackets val New host first error1. Parse the file, process only the field as a key in the fields dictionary, and return the list of values in the Clean up dictionary Demand: 1. Change the dictionary keys according to the mappings in the fields dictionary 2. Delete the extra instructions in the parentheses in "Rdf-schema#label", for example "(spider)" 3. If "name" is "NULL" or contains non-alphanumeric characters, set it to the same value as "label" 4. If the value
Use Environment
elasticsearch5.1.1
kibana5.1.1
Synonyms plugin 5.1.1
Installing plugins
download the corresponding elasticsearch-analysis-dynamic-synonym-5.1.1.zip, unzip to the local elasticsearch/plugins directory, restart ES
first way local file
Description:
for local files: mainly through the file modification timestamp (Modify time) to determine whether to reload
in the Elasticsearch/config directory, set up the analysis directory, and p
parameter global_name=true requires that the database link name is the same as the remote database name. The database global name can be isolated with the following command
--select * from Global_name;
3. Query data:
--querying, deleting, and inserting data is the same as manipulating the local database, except that the table name needs to be written as "table name @dblink Server".
Select xxx from table name @ database link name;
4. Delete DBLink
Drop/ * pub
) (HOST = 192.168.0.1) (PORT = 1521))) (Connect_data = (SERV Ice_name = ORCL)) ';
--Database parameter Global_name=True requires that the database link name is the same as the remote database name. The database global name can be isolated with the following command
--select * from Global_name;
drop database link to_test;Create DATABASE link To_test connect to dbzy_20140903 identified by dbzy_20140903 using ' (DESCRIPTION = (address_lis T = (ADDRESS = (PROTOCOL = TCP) (HOST = 1
The concept of synonyms:Synonyms are aliases of Oracle objects and use synonyms to access the same objectsYou can create synonyms for objects such as tables, views, stored procedures, functions, or another synonymEasy access to other users ' objects, hiding the identity of the objectShorten the length of the object nameSynonym creation Syntax: CREATE [public] synonym synonym_name for object;Permissions to create and delete synonyms:
CREATE
1. Due to a 0xc0000b error on Win8 's computer, the Linux system in the virtual machine is now being used. installation process See http://blog.csdn.net/yuzhongchun/article/details/124924632. Data types and variablesThere is no difference between this basic and the data type in C, the thing to be aware of in the operation is,//operation, 10//3=3,//the integer part of the quotient of this operation taking the division operation. EG:19//4 = 43. Output of the stringThe processing of strings in Pyth
, wrote and tore off, tore and write. But there were two things I was most excited about when I was third day. First, when doing chemical experiments, she took a few beakers from home, and I was going to have one. But on the way home in the evening, I took out to show off, was the same village classmate borrowed, I also very generous outfit do not care, in fact, my heart regret death. Another thing is the junior high School examination we test are ver
()# Print (ret)# def func ():# return {' K ': ' V '}# Print (func ())# def FUNC2 ():# return #return## r= Func2 ()# print (R)# def My_len (s): #自定义函数只需要0个参数, receive parameters, formal parameters, formal parameter# i = 0# for K in S:# i + = 1# return I #返回值## ret = My_len (' King boss Little Nurse ') #传递参数: parameters, actual arguments, arguments# ret = My_len ([1,2,3,4,5]) #传递参数: Parameter transfer# Print (ret)#什么叫参数?#参数的语法#形参和实参的概念# def F2 (L1):# f1 (L1)# for I in L1:# Print (i)## def F1 (L1)
The list in Python is quite the same as the array in C, List: Lists initialized using [], tuple: tuple initialized using ();A list of lists1 #!/usr/bin/python23 #list初始化: []4 classmate = [' s ', ' su ', ' Sum ', ' sume ', ' Sumey '];56 print classmate;7 print classmate[0]; #第一个元素: S8 print classmate[-5]; # negative, i.
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.