Oracle

Create a temporary table spaceCreate temporary tablespace test_tempTempfile ' D:\app\orcl\oradata\temproryTestUserSpace\test_temp1.dbf 'Size 10m autoextendOn next 10m maxsize 50m extent management local;Create a data table spaceCreate tablespace

[Email protected] ~]$ mkdir datadump[Email protected] ~]$ CD datadump/[Email protected] datadump]$ pwd/home/oracle/datadumpsql> Create or replace directory DIR_DP as '/home/oracle/datadump ';Directory created.Sql> Grant Read,write on directory

DBV (dbverify) is a command-line tool provided by Oracle that can check both physical and logical consistency of data files. However, this tool does not check the matching relationship of index records and data records, which must use the Analyze

Oracle queries all tables under the userSELECT * FROM all_tab_comments– queries all users ' tables, views, etc.SELECT * FROM user_tab_comments– query This user's table, view, etc.SELECT * FROM all_col_comments– queries the column names and comments

Scott users are a very important experiment in our process of learning Oracle, and when we build a database, the Scott user does not appear by default if we choose a custom mode, but we can make this user appear by using a few simple commands. The

2.20 y,yyy Returns a comma-separated display of the yearSQLSelect To_char (systimestamp,'y,yyyfrom dual; To_char (Systimestamp,'y,yyy')-----------------------------2,015 2.21 Y/YY/YYY/YYYY Returns the year of the date at the specified

Sort after adding nulls last in descending order, put null in the finalSelect To_char (sysdate, ' Q ') from dual;Dual pseudo-table public synonym because it has a record for easy readingSelect RowNum, ' A ' | | Rownum,mod (rownum,2) from dual

1. Download the SHP2SDO, copy the shp file to shp2sdo the same path, open the Windows command window and execute:SHP2SDO shp file name Table name-I id-s 4326-dExample: SHP2SDO City tb_city-i id-s 4326-d2. Open the Plsql Command window, execute (can

Interview: Exp/imp logical backup and recovery: Two, storage storage migration: Data files, control files, log files, SPFile to the new machine, and then start the database on the new machine. Third, the use of data Guard migration: four, using Rman

Excerpts from the official documents of 11g:      unusable  specify unusable to mark the index or index partition (s) or index subpartition (s) UNUS ABLE. The space allocated for a index or index partition or subpartition is freed immediately when

1, with the DBA role of the user login, unlock, first set the specific time format, in order to see the specific timeSQL>alterset nls_date_format='yyyy-mm-dd hh24:mi:ss '; Session altered.2, check the specific lock timeSQL>Selectfrom where username=

Create 999; -- Are you sure the serial number is only 3? Use the next value for it with: Seq_abc_taskid.nextvalQuery current value by: Seq_abc_taskid.currvalFor example, if you want to insert a line to ABC now, you canInsert into Values (1,

12c, how to connect pluggable database: Using the default service connection PDB, after creating the PDB, automatically adding the PDB-named service in the listener; The user creates a service in cluster, and the user creates a service

Select To_char (Trunc (Add_months (Last_day (Sysdate),-1) + 1), ' yyyy-mm-dd ') "The first day of the month",To_char (Last_day (sysdate), ' Yyyy-mm-dd ') "Last day of the month" –oracle trunc () function usage/************** Date ********************

First of all, the Oracle 9i added a new system comes with the sorting function1. Sort by first letterNew in oracle9i, according to pinyin, radicals, stroke sorting function. Setting the Nls_sort valueSchinese_radical_m Sort by radical (first order),

Oracle Login ora-01033:oracle is initializing or shutting down the workaround2015-03-16 01:20 | 160511 people reading | sourceOracle Login ora-01033:oracle is initializing or shutting down the workaroundOracle has multiple instancesThe corresponding

PL/SQL Release 11.2.0.4.0-production export version, database address 10.36.40.53PL/SQL Release 11.2.0.4.0-production import version, database address 10.36.40.7410.36.40.53 the database address that needs to be migrated1. [[email protected] ~]#

Recently, in the process of learning, found a very interesting function, it can achieve the concatenation of the column values. Let's take a look at its specific usage.Usage:The official documentation for its role is explained below:For a specified

Transferred from: chenoracle:http://blog.itpub.net/29785807/viewspace-1744718/Startup shutdown considerations1 The start of ASM instance and the start of DB instance have strict relations, ASM boot must be earlier than the database instance,

1.union: Perform a set operation on two result sets, excluding duplicate rows, and sorting the default rules;SELECT * from emp where Sal 2.union All: Perform a set operation on two result sets, including repeating rows, without sorting;SELECT * from