Oracle

Purpose:Regular backup of database data to avoid data loss or errors Implementation Method:Oracle export + windows Task completed Learning Method:To know why Implementation process: 1. Create a file backup. bat (custom file name. bat) @ Echo off

Index categoryOne Binary tree Index, or B-tree indexes, is the most widely used index. by default, all indexes we create are B-tree indexes. b-tree index based on binary tree principles 2. Binary tree clustering index (B-tree Cluster indexes) is

Delete crs 1. stop resources: Disable crs resources: crsctl stop resources Disable crs: crsctl stop crs 2. Run the following Script: root. delete. sh and rootdeinstall. sh nodes. 3. Delete the startup Item: Rm/etc/oracle /* Rm-f/etc/init. d/init.css

  Bytes -------------------------------------------------------------------------------------------------------- When connecting to the Oracle database using PL/SQL on the server, a problem occurs, prompting: Initialization error Cocould not load "F:

I used to take notes when I was studying oracle. When I started to read my computer today, I suddenly felt a little unfamiliar. It was a pity to delete it. I didn't delete it on my computer and didn't read it again, therefore, you should review it

This is a relatively biased knowledge, but it has a lot of practical significance and can help DBAs complete some daily management work, for example, you can disable some user functions (prohibit users from modifying or deleting a table, and

ORACLE-based application systems have many performance problems, which are caused by poor SQL Performance of application systems. Therefore, SQL Performance optimization is very important, to analyze and optimize the performance of an SQL statement,

Summary of oracle stored procedures and the use of ref cursor: mainly records the knowledge about oracle stored procedure, from definition to use. Start with the simplest example and go deeper. At the same time, the use of ref cursor is combined

Clear Shared pool: Alter system flush shared_pool; However, to clear the entire memory, we had to shut down the instances and databases in the entire Oracle RAC environment and restart them. You can clear the buffer cache: Alter system flush

1. Forget the logon password of a user except SYS and SYSTEM. Log On with the sys or system user and modify the Database Password. # Sqlplus sys/oracle @ "sid" as sysdba use the following statement to modify a user's password: SQL> alter user

The role of Data Gurad is not much said. Here, we will talk about the building steps of physical standby.There are roughly three ways to create a standby DatabaseMethod 1: Use rman to generate standby. (use rman's duplice method for direct creation

After logging on to the database for a small test today, I forgot to use the command to delete the tablespace and deleted the data file in Linux, As a result, the tragedy begins. (I figured out how to work out study together) Lab

Create Table space tyger2 in the database and delete the data file tyger2_01.dbf in the linux system file. An error is returned when the database is started, Re-create the file named tyger2_01.dbf. The database starts normally, but the data in the

-- How to Use the grade Table data to update the usertable data (with the associated field userid)Update usertable u set u. grade =(Select g. grade from grade g where g. userid = u. userid ); -- How to generate serial numbers for query result

Purpose: Test the function of disabling the database and deleting the data file.(Back up data files)When the database is started, an error is reported. How can I restore the data file ?? How to restore data files without changing paths and data

Essential Oracle statements -- Query table space usageSelect upper (F. TABLESPACE_NAME) "tablespace name ",D. TOT_GROOTTE_MB "tablespace size (M )",D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M )",TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F.

This problem has been entangled in me for a whole morning. The key issue is not that there is no way but that the method is not correct! I initially followed this

Exists: the condition is true when the subquery returns at least one row. Not Exists: the condition is true if the subquery does Not return any row. In: It is equal to a value In the returned result set of the subquery. Not In: it is Not equal to

This blog is intended for beginners and I am also a beginner :) We have successfully installed oracle on our computer, so how can we connect PLSQL developer? What about local oracle? First, we must prepare for the following steps: The following

How to export empty tables in oracle 11g Due to the new features created by the delay segments of oracle 11g, oracle does not allocate data segments when no data is inserted. In this case, exp cannot export empty tables of the 11g Database. Of