Oracle

Get table field:SELECT *From User_tab_columnswhere table_name= ' user table 'ORDER BY column_nameGet Table Comments:SELECT *From User_tab_commentswhere table_name= ' user table 'ORDER BY table_nameGet field Comments:SELECT *From

first, the audit classification: Oracle's audit in general can be divided into "standard audit" and "fine-grained audit" the latter is also known as "policy-based audit", the function has been greatly enhanced after oracle10g. Standard audit can be

Transferred from: http://blog.csdn.net/zhangchu_63/article/details/5543377The following connections are the theory of materialized views: http://blog.csdn.net/tianlesoftware/article/details/4713553The company's project encountered the need to take

just like completing the JDK installation, you need to configure the environment variable java_home and path for the system to let the system know the Javac command inside the JDK. Similarly, there is a process required to install Oracle. When you

How Java passes a list to an Oracle stored procedure. Examples include the following:An array of PL/SQL is built on the database side.CREATE OR REPLACE TYPE Tables_array as Varray (+) of VARCHAR2 (+);d ROP table Test purge;create table Test ( name

Rapid recovery of Oracle in #加深对Linux句柄的理解/emergency situationsUnlike dropping data files from Oracle, in some cases it may be possible to encounter a database at runtime when the data file is deleted at the operating system level, while the Oracle

there is a big difference between the mode of the database system, the internal mode, and the external mode, in order to realize the transparency between the user and the data, the DBMS provides a two layer image: Outer mode, pattern image and

the integrity constraints of data are some constraints on the data description, and three types of integrity constraints can be found in the relational data model: Entity integrity, referential integrity, and user-defined integrity.

Relationship between two parameters: Sessions=1.1*processes+5The current summary of the statement, in view of the data connection is very useful, after writing the program while testing the code side to see the release of database connections to

This is due to the fact that the exported DMP file differs from the version of the imported database.Using notepad++ to view the DMP file, change the version number in the header to the target database you will import intoThe following version

After 9i, the internal component size of the SGA can be dynamically adjusted or automatically managed by the database, and when the memory size is set, the basic unit of allocation is granularity (granule) granule is a contiguous virtual memory,

All tablesSelect from // tables owned by the current user Select from // Selectfrom// including system tablesNotes for TablesSelect * from // comments for the current user owning the table Select * from // comments for all user tables

1. Check the master standby sync status2. Turn on the flash back function and flash back directory of the standby library3. Cancel the recovery process for the repository4. Create a restore point for the standby library5. Archive logs in the main

1. Check the current master standby sync status On primary SelectADS.DEST_ID,Max(sequence#) " CurrentSequence ",Max(log_sequence) "Last Archived" fromV$archived_log al, v$archive_dest ad, V$archive_dest_status

 in the process of doing the project, a page uses a similar example of the following SQL query data. For the sake of secrecy and ease of use, I replaced the table names and fields in the project with the system tables and fields in the ORACLE

Oracle Learning1. Create a constraint for the table :ALTER TABLE name ADD CONSTRAINT constraint name constraint contentDemo sample: Alter bable infos add constraint un_stunsme unique (stuname)//UNIQUE constraint;ALTER TABLE scores add constraint

Looking for a big circle on the internet, not finding the right tools to track Oracle's SQL for some time.Our scenario is intended to automate all scenarios (RFT) +fiddler tracking request + back-end tracking SQL, based on the results to analyze the

The SQL language is divided into four categories:Data Query Language DQL:The DQL basic structure of the data query language is a query block consisting of a SELECT clause, a FROM clause, a WHERE clause.Data Manipulation Language DML:DML is shorthand

Rman ( physical Backup)Rman-recover Manager Rman backed-up objects Data Files Data Files (Data File) Control Files Control Files (Control File) parameter File parameter File (Spfile/pfile)

using Zabbix to monitor Oracle Here we use the Open source Orabbix project, software:Https://nchc.dl.sourceforge.net/project/orabbix/orabbix-1.2.3.zipAttachments can also be downloadedDeployment Methodwhen the download is complete , it is placed on