synonym = alias of tableGrammar:CREATE [public] synonym synonym name for database object;Example One, -- user created with administrator or with the Create SYNONYM permission -- create synonyms for Scott CONN sys/ Change_ On_install as SYSDBA; create Synonym myemp fo
the cache.NoCache: The serial number is not pre-allocated for faster access, and if the cache and Nocache,orcale are ignored when the sequence is created, 20 serial numbers will be cached by default. To access the value of a sequence through a pseudo-column of a sequence Nextval returns the next value of the sequence Currval Returns the current value of the sequence 04.sys_guid function 1 --Create a sequence
2 Createsequence Seq_first3 --querying the next sequence
4 SelectSeq_first.nextval from
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
In the help of imp: SHOW just list file contents (N). The default value is N.
The Code is as follows:
Copy code
In the help of imp: SHOW just list file contents (N). The default value is N.The following experiment explains two points:1. show = y: displays the statements for creating objects in the dmp file.2. show = y, as oracle said, just list file contents. Import is not performed here.Prepare the experiment environment:1. Create a user and grant permissions:SQL> create
. This function is not applicable to multi-table join queries. the database administrator must. set appropriate parameters for this region in 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 between the two. To achieve sharing, the SQL statements must be identical (including
encapsulation of V _ $ INSTANCE. GRANT dcsopen permission TO query v $ instance: SQL> GRANT SELECT ON v $ instanceTO dcsopen; GRANT SELECT ON v $ instance TO dcsopen * ERROR at line 1: ORA-02030: can only select from fixed tables/views does not allow query permission granted to it? Are there other objects in V $ INSTANCE? Except for this synonym. SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = 'v $ instance'; OWNER OBJECT_TYPE ---
In the dynamic performance view, there are changes in the oracle runtime. The changed data is stored in the dynamic performance table (memory table, fixed table), which is created as the database starts up, the dynamic performance table is too complex as the content is added as the database runs. On this basis, oracle creates a view and synonym for DBA to determine the system performance status information.
In the dynamic performance view, there are c
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. Can contain letters, Data, underscores, $ ,#
Objects in the same solution (User) cannot be renamed. Oracle reserved words cannot be used
Supplement: tables in Oracle databases are divided into user-defined tables and data dictionary tables.
User-Defined tables: A group of tables created and maintai
In the help of imp: SHOWjustlistfilecontents (N), the default value is N.
In the help of imp: SHOW just list file contents (N). The default value is N.
In the help of imp: SHOW just list file contents (N). The default value is N.
The code is as follows:
In the help of imp: SHOW just list file contents (N). The default value is N.The following experiment explains two points:1. show = y: displays the statements for creating objects in the dmp file.2. show = y, as orac
. Create an index on one or more columns
Create index indexname on table (column [, column]...);
Ii. Create an index on LAST_NAME In the EMPLOYEES column of the table
Create index emp_last_name_idx on employees (last _ name );
Index create.
D) index creation period
I. index creation
1. Wide data distribution in Columns
2. Columns often appear in the where clause or join condition.
3. Tables are frequently accessed with a large amount of data. The amount of data accessed is about 2% to 4% of the
Drop Index;
Ii. Delete the index upper_last_name_idx
Drop index upper_last_name_idx;
Iii. Only the index owner or users with the drop any index permission can delete the index.
2. Synonyms
A) advantages of using Indexes
I. convenient access to other user objects
Ii. Shorten the Object Name Length
Iii. Create [public] synonym Synonym
III. For object;
B) Create a
, roles, tablespaces, tables, views, clusters, types, synonyms, sequences, indexes, database links, stored procedures, functions, packages, and triggers. C. Oracle combines these database objects into a collection called Schema. A Schema can only be owned by one data user, and its name is the same as that of the user.
14. TableIn Oracle, the table concept and syntax for creating, deleting, and modifying tables are basically the same as those in other databases. Common Data Types of Oracle tables
WordNet Research 2 -- Introduction
Structure
The main relation among words in WordNet is synonymy, as between the words shut and close or car and automobile. synonyms -- words that denote the same concept and are interchangeable in your contexts -- are grouped into unordered sets (synsets ). each of WordNet's 117 000 synsets is linked to other synsets by means of a small number of "Conceptual relations. "Additionally, a synset contains a brief definition (" gloss ") and, in most cases, on
, 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
database name. The database global name can be identified with the following command--select * from Global_name;
3, query data:
Querying, deleting, and inserting data is the same as manipulating a local database, except that the table name needs to be written as a "table name @dblink server."Select xxx from table name @ database link name;
4, delete Dblink
Drop/* Public */Database link dblink1;
5. Create and delete synonyms
Create or replace synonym
SQL statement to Oracle, Oracle first looks for the same statement in this block of memory.What needs to be noted here is that Oracle is a strict match between the two, and to achieve sharing, the SQL statement mustExactly the same (including spaces, line wraps, etc.).
The shared statement must meet three criteria:A. Character-level comparisons:The statement that is currently executed and the statements in the shared pool must be identical.For example:
SELECT * from EMP;
is different from
the shared pool must be identical.
For example:
SELECT * from EMP;
is different from each of the following
SELECT * from EMP;
Select * from EMP;
SELECT * from EMP;
The objects referred to in B. Two statements must be exactly the same:
For example:
How user object names are accessed
Jack sal_limit private synonym.
work_city public synonym
Plant_detail public
Tags: flashback synonym shutdown Lin ODBC data source HBA using open computerCommon exceptions:ORA-14025: Cannot specify partition for a solid view or a solid view logOra-14026:partition and cluster clauses repel each otherORA-14027: Only one partition clause can be specifiedORA-14028: Missing at or values keywordsOra-14029:global partition index must be prefixedThere are non-existent partition columns in the ora-14030:createtable statementORA-14031:
the permissions of the database server settings ALTER TABLE modify the owning table permission alter TABLESPACE repair Change the permissions of the tablespace alter user to modify the permissions of the users analyze use the Analyze command to parse any tables, indexes, and clusters in the database audit any set audit options for any database object audit system allows systems to operate audit backup any T Able the right to back up any table become user to toggle the permissions of the users s
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.