Oracle

I. Control file multiplexing1.show parameter control--View Control file informationShow Parameter SPFile--see if there are spfileCreate Pfile from SPFile;--Generate PfileShutdown immediate--Guanqu2. Modify the Pfile file to add multiple pathsVI

Select t.recd_id from (select recd_id, ROWNUM RN from RT_TICKETS_BIS_RECD) t where T.rn = (select round (dbms_random. VALUE (1, COUNT (1))) from RT_TICKETS_BIS_RECD); 1) Select Round (dbms_random. VALUE (1, COUNT (1))) from RT_TICKETS_BIS_RECD

1. System tablesThe system parameters of the Oracle database are stored in the database and can be queried by the user Sysytem through Sqlplus. A few important tables or views are as follows:V$controlfile: Control the information of the

Common Sql*plus commands and environment variables----------------------------------query table Structure Command: describe (abbreviated DESC)Set Display output width: Set line [size] {80|n}List the statements for the SQL buffers: list (abbreviation

After the Oracle database is started, you can view all the parameters used by the Oracle database by using the select * from V$parameter statement . For Oracle 's parameter files, it is divided into spfile binaries and pfile text files, and now the

Objectivethese last few days have been working with Oracle database, due to previous Oracle The study is not deep, just put Oracle As a data source to use, a lot of things do not know very deep, such as databases, database instances, table space,

Today in the local configuration of the Oracle client, once again need to link the service side of the LAN machine, the estimated need to configure the tnsnames.ora file, make a record, prevent the next use, once again search configuration method:

We all know that PL/SQL can copy data to Excel, and we can also insert data into the database via Excel.Let's take a simple example with a demoFirst, we create a table testCREATE TABLE Test (ID number);Then we execute the following statementSELECT *

Oracle 's data structures are divided into physical and logical structuresPhysical Structure: Data block of the operating system-> data file datafilesLogical Structure: Minimum database block-->extent-->segement--> Tablespace-->databasesWhere for a

Methods for Oracle to delete all tables under the current user1. If you have permission to delete a user, you can:Drop user user_name cascade;Add the cascade can delete the user data.Delete and then create the user. --Create Admin user user name

CREATE TABLE DBO. Index_policy_tbl(ID Number (Ten) is not NULL PRIMARY KEY,policy_id number (10,0) default ( -1) is not NULL,Alarm_count Number (Ten) default (0) not NULL);ALTER TABLE DBO. Index_policy_tbl ADD (c_name_1 VARCHAR2) not NULL, c_name_2

Oracle IndexManaging indexes-Introduction to Principles? IntroducedAn index is a data object used to speed up data access. Proper use of indexes can significantly reduce I/O times and thus improve data access performance. There are many kinds of

Install Client services only to use PL/SQL to connect Oracle========================================First download the Oracle corresponding client software, such as Instantclient_11_1 followed by the following steps.1. Place the instantclient_11_1

Today in the Oracle database is encountered Oracle cannot delete the current connection user, after the search can be resolved as follows.   Prompt when deleting a user in Oracle: Oracle cannot delete the current connection user can use the

Oraclesqlnotin multi-field comparison exampleSelect * from (select t2.cadastralno parcelid, t1.pkid taxpayerid, t2.taxtype taxtype, t1.booktype taxpayertype,T2.cadastralno parcelCadastralno, t2.landuser parcelLanduser, t1.payername taxpayernameFrom

Oracle Basic Data Change Principle Analysis (redo and undo) -- oracle Core Technology reader I In oracle, we have made some update operations. How does the bottom layer of oracle flow? This is what we will explain in this article. I.

How can a user in oracle access tables of other users without using the user name? The background of the story is as follows: a project involves about four projects for simultaneous development. In my own project, I need to make a report, but

Introduction and instance demonstration of blocked in Oracle RAC environment, racblocked The blocking in the RAC environment is different from that in a single instance, because we need to consider the session in different instances. That is to say,

Introduction to Oracle blocking blocked and instance demonstration, blockingblocked Blocking is a common situation for DBAs. especially poor application design blocking can cause serious performance degradation until the database crashes. For DBA,

Oracle index usage script sharing, oracle Index Oracle provides the index monitoring feature to determine whether an index is used. In Oracle 10 Gb, the index is monitored when statistical information is collected. In Oracle 11 GB, this phenomenon