Oracle

Script: #! /Bin/bash Newfilename = 'date + % Y % m % D'. dmpNewlogfilename = 'date + % Y % m % D'. LogCD/Oracle/backup Exp user/Password Buffer = 102400000 file =/Oracle/backup/dump. dmp log =/Oracle/backup/dump. Log tables = (tablea, Table2,

A colleague wrote this article. Let's share it with you.   Create Table score(Fname nvarchar2 (50 ),Fsubject nvarchar2 (50 ),Fresult decimal (18, 0));Insert into score values ('zhang san', 'China', 20 );Insert into score values ('zhang san',

Backup Error 1: RMAN-03009: BackupCommand(Ora_disk_1On the channel,In07/28/2012 10:23:22Upper) ORA-19602: failed to back up or copy active files in noarchivelog Mode The reason is: automatic archiving is not enabled. Solution: 1. Enable

If you have already deleted Sqlplus sys/orcl as sysdbaDrop user oawf1;Drop tablespace oawf1;Then manually delete the tablespace file. // Create a tablespace in Oracle. Create a tablespace. Grant the DBA permission to import DMP data files.// Log

Address: http://wentao365.iteye.com/blog/1156889 Sign Function: Used to determine whether a value is positive, 0, or negative. The returned values are 1, 0, and-1 respectively. Decode function: Decode (expression, value 1, result 1, value 2,

Important reference 1: Important reference 2: Important reference 3: Reference slides 11g Data Dictionary reference Importance: Because the data dictionary contains user information, we need to query the data dictionary when logging on, and have

35 Here are some explanations. 1: Undo segment Concept When the database is modified, you need to save the old data to a place and modify it. The segment used to save the old data is the Undo segment. Previously, old things can be overwritten,

In actual work, you sometimes need to modify the user name, and the common practice is the exp imp method. If the data volume is large, the exp imp method will waste a lot of time, the following describes how to modify the user name by modifying the

I recently learned how to use proc for Oracle application development. However, I did not have much detail about this on the Internet. After some twists and turns, I finally completed a test case. The function implemented by the program is very

Today, the user requires that all data 0 cannot be involved in the average calculation. The idea is that the AVG function itself does not participate in the calculation of NULL data. Therefore, you only need to convert zero data to null, I thought

The Oracle database uses the sqlnet. authentication_services parameter in the sqlnet. ora file, remote_login_passwordfile In the parameter file, and pwdsid. ora parameter file to implement identity authentication. Sqlnet. authentication_services =

1) CheckOracleSystem temporary tablespace size: Select sum (bytes)/1024/1024 "Temp size (m)" from dba_temp_files where tablespace_name = 'temp ';   2) QueryUndoTablespace size Select sum (bytes)/1024/1024 "Current undo size (m)" from dba_data_files

  1. query the records of the row Select Sal from EMP where rownum = 1; // query the first row of records. Select Sal from EMP where rownum = 5; // The fifth row record cannot be queried because rownum is always queried from 1, therefore, this

-- Query data by system date (sysdate)Select * From t_br_salesdtl A where a. fstoreid = 191 and A. ftime> = to_date (to_char (sysdate-1, 'yyyy-mm-dd'), 'yyyy-mm-dd ')-- Query data based on the given date (eg:)Method 1:Select * From t_br_salesdtl A

--- Use an oracle user to go to sqlplus to delete the user and create another user and grant permissions -- The permission must have synonym; otherwise, an error occurs when the imp dmp file is used. Su-Oracle Sqlplus/As sysdba Drop user base

Oracle concurrency uses multiple CPUs and Io to perform database operations, which can significantly improve the operation performance of large databases, such as DSS or data warehouses. Applicable Large Table query, join, and partition index

1. PLSQL debugging stored procedure: 1. Configure the connection in Oracle configuration and migration tool named ". net manager" 2. Create an SQL window in PLSQL and write the Stored Procedure 3. Create a test window in PLSQL and call between

Include the SQL statement in select (...) from dual. Logic description: Currency + header opening date associated exchange rate maintenance (original currency code, effective date range), get conversion rate, Then, the amount is converted to the

1. Describe the relationship between tablespace and datafile Tablespace is a logical component of the database. Physically, the database data is stored in the data file. Logically, the database is stored in the tablespace, which is composed of one

It was originally with images. when the results were saved, too many images were lost (Crying fast) Download Li Xinghua Oracle video notes: Click to open the link I'm using Windows 64-bit, Oracle 10: