Oracle

--View table space Select Tablespace_name,file_id,file_name,round (Bytes/(1024 * 1024), 0) | |  M ' Total_spacefrom dba_data_filesorder by Tablespace_name; --Creating tablespace Create tablespace testlogging datafile '/data2/js/test_01.dbf ' size

There are parentheses in the program Files (x86) path of the 64-bit Win7 system, and Oracle does not recognize such a path, so there is a problem that the database cannot be connected. So we can copy VS2010 's internal debug Web server

1, the applicable system is different: Bitmap index is suitable for OLAP system, and B-tree index is suitable for OLTP system.2, occupy different storage space: Bitmap index requires only a small amount of storage space, and the B-tree index needs

Create a temporary table space create   temporary   Tablespace test_temp tempfile  " c:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf " size 32m autoextend  on next  32m maxsize 2048m extent management local; Create a

Yesterday at noon, query to the server data running the latest record is 8 in the morning, the field View service log is very strange, the log output shows hanging dead in the database connection this step. Many times debugging no results, and then

2015-09-24Vim/etc/rc.d/init.d/oracle#!/bin/bash# Oracle:start/Stop Oracle Database 11g r2# chkconfig:345 - Ten# description:the Oracle Database is an Object-relational Database Management system.#./etc/rc.d/init.d/Functionslockfile=/var/lock/subsys/

Execute the following commands by using SYSTEM account login Oracle:　　>sqlplus System/[email Protected]:1522/xe;Sql*plus:release 12.1.0.1.0 Production on Tue Sep 22 20:16:29 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle

Linux Setting Oracle Environment variables Method One: Run the export command directly to define the variable, which is valid only under the current shell (bash) or its child shell (bash), the shell is closed, the variable is invalidated, the new

ORACLE Database Simple testOperating system: Windows 7–Oracle:oracle Database 10.2.0.4First, the purposeTest the startup listener, the database is not the same user, whether the user can log on to the databaseIi. Introduction of the

1. Modify the data in the table: UPDATE statement:Grammar:Updtae table_name SET = value1,... [WHERE conditions](2), unconditional update (without a Where condition update): sql> update userinfo set userpwd= " 111111 " ; 4 rows updated. SQL >

1. Add data to the table (Insert statement):Syntax to add:INSERT into table_name (column1,column2,column3,......) VALUES (Value1,value2,value3,...)The fields after table_name can be omitted, except that each field of values must match the

1. Deleting data: Delete statement:Grammar:DELETE from table_name;(1), unconditional deletion:SQL>createtable testdel 2as Select * from userinfo; The table was created. SQL> Delete from Testdel; 4 rows deleted. SQL>Select* from testdel; rows

First, language classification1.DML (Data Manipulation Language): Used for data manipulation.　　DML includes: (1) SELECT: query dataSelect * from temp;(2) INSERT: Add data to DatabaseInsert into Temp Values (4,' Harry ');(3) UPDATE: Used to modify

Transferred from: http://blog.csdn.net/liusong0605/article/details/16349121After completing the installation of Oracle and starting the service, you cannot log on by Sqlplus and the following error occurs:SP2-1503: Unable to initialize Oracle call

The set operation does not apply to lob,varray and escape table columns union, intersect, minus operators do not apply to long if the selection list contains an expression or function, you must define the column alias 1, Uinon: No weight union, for

The oracle dg slave database does not synchronize the data of the master database. Today, a database synchronization problem occurs. The master database is shut down. After the master database is restarted, the slave database cannot synchronize the

Explain the usage of distinct in oracle, oracledistinct Let's take a look at the example below: Table Field 1 Field 2 id name 1 a 2 B 3 c 4 c 5 B The library structure is like this. This is just a simple example, and the actual situation is much

Introduction to the long raw blob clob type in OracleRAW: unprocessed type, which can store binary data or LONG, a variable-length string data. The longest value is 2 GB. LONG has the feature of VARCHAR2 columns, you can store up to one LONG column

Goldengate synchronizes one-way DDL operations in Oracle for OracleWe will perform the following test on the source end to execute the table's truncate SQL> truncate Table tcustmer; table truncated. on the target end, check the table data SQL>

Oracle learning-Data Warehouse (2) DimensionIn a data warehouse, there are two concepts: fact table and dimension table. A fact table is a central table in the data warehouse structure. It contains the numerical measurement values and keys that