Oracle

☆dba_ opening .....Dba_users Database user InformationDba_segments Table Segment InformationDba_extents Data Area InformationDba_objects Database object InformationDba_tablespaces database table Space informationDba_data_files Data File setup

Create a new temporary tablespace Tmpa Create temporary tablespace tempa tempfile '/oracle/tmp/tempa01.dbf ' SIZE 8192M reuse autoextend on NEXT 1024K MAXSIZE UNLIMITED;2. Specify the default temporal tablespace as TmpaALTER DATABASE default

Version 12.1, Cdb-rac modeOne cluster, 4 nodes, one CDB, with 12 pdb below.Os:linux 64---Delete UserDrop User C # #testAtler.log TipsOra-00600:internal error code, arguments: [Ktpjptsr-nocurtxn], [], [], [], [], [], [], [], [], [], [], []Incident

In the actual work, will inevitably encounter serial number generation problem, the following is a simple sequence number generation function(1) Create a custom serial number configuration table as follows:---Custom sequence CREATE table S_autocode (

1.ASCII returns the decimal number corresponding to the specified character;Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;A A ZERO SPACE--------- --------- --------- ---------65 97 48 322.CHR gives an

Oracle Flash Back Technology1.Flashback Database2.Flashback Drop3.Flashback Table4.Flashback Query1.Flashback Database (recovery with flashback log)Description: The Oracle Flashback database feature allows SQL statements to be Flashback to databases

DECLARETYPE cst_table_list is Table of VARCHAR2 (40); TYPE Cst_list is TABLE of VARCHAR2 (40);TYPE Name_list is TABLE of VARCHAR2 (40); TYPE Type_list is TABLE of VARCHAR2 (20);Cst_tab_name cst_table_list:=cst_table_list (); Cst_name

A few days ago suddenly received a leadership task, to the oracle of several tables in the format of access to export, for never contact with access to me, heard this task a little confused, so began to find Niang, after a few hours of unremitting

Problem:Statement 1:SELECT * FROM table1 A where a.col1 not in (Select col1 from Table2 B)Reprint Annotated Source: http://x-spirit.iteye.com/, http://www.blogjava.net/zhangwei217245/If so, there should have been a piece of data, the result is

Left Outer connection (outer join/left join)SELECT * from a LEFT join B on a.id = b.ID;SELECT * from a b where a.id = b.ID (+);With (+) to achieve, the + number can be understood as follows: + to supplement, that is, which table has a plus, this

To start and shut down a database, you must log in as a user with Oracle Administrator privileges, typically logged in as a user with SYSDBA permissions. Generally we use the SYS user to start and close the database with a SYSDBA connection. Here

One, stored procedures can not be used directly in the Insert,update,delete, you can have a return but the exit process has three types: do not return a value, you can return multiple values, there are three types of parameters, such as: in: Enter

installation environment and system requirements (the specific parameter values and paths below are adjusted according to your environment)Operating systems: Red Hat Enterprise Linux 6 (x86) or CentOS 6 (x64)Database: Oracle 11g R2 32-bit for Linux

This error occurs because the hostname and/etc/hosts file are inconsistent, just need to write the hostname and its IP/etc/hosts file, OK.Note that the name cannot be underlinedChange the network file, and then use the hostname command to specify

String typeFixed length: char nchar n denotes Unicode encodingVariable length: varchar2 nvarchar2Numeric type: Number (p,s) P: integer digits, S decimal placeInteger integersBinary_float Single floating pointBinary_double Double floating pointFloat (

Specific tips:Could not load file or assembly ' oracle.dataaccess ' or one of its dependencies. An attempt was made to load a program that is not properly formatted.Description: An unhandled exception occurred during, the execution of the current

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

Use Requirejs to add third-party tools or libraries in Oracle JET applications.Steps:1. If you use a tool frame scaffold, you need to do it.A. Use NPM to install the libraries you need.NPM Install My-library--saveB. In the Script/grunt/config

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

Open SQL Plus to unlock and change your password under SQL Plus, as follows:Run---> cmd---sqlplus, prompting for a username, where we first enter with the Administrator account: System----The account has higher permissions than Scott,Enter the set