Oracle

We all know that after the Oracle database installation, the default will have such a number of system roles or permissions, Nomal,sysdba,sysoper, and so on, each time you log in to Oracle, is directly logged in as Conn/as sysdba, But I never knew

Create user Mchis profile ' DEFAULT ' identified by ' mchis#150 ' account unlock;grant dba to Mchis;Modify one of the Mchis (user name) mchis#150 (login password) Mchis (with user name consistent, function as authorization) This

Oracle create user, grant permissions, and delete user create user Oracle to tablespace users without permission alter user username quota unlimited on users;Creating a temporary tablespace create temporary tablespace test_temp tempfile '

1, download MYSQL-CONNECTOR-ODBC, and install2. Windows: Control Panel, administrative Tools, data source (ODBC)->ODBC Data Manager, System dsn-> add->mysql ODBC Driver->data Source Name (for example:mysql_data)DescriptionTCP/IP server (server

Basic syntax and examples:I. EXP: There are three main ways (full, user, table)1, Complete: EXP system/manager buffer=64000 file=c:\full. DMP full=y If you want to perform a full export, you must have special permissions2, User mode: EXP sonic/sonic

The following article reproduced from: http://www.cnblogs.com/200911/archive/2012/07/26/2610018.html, thank youThis feature greatly improves the performance of SQL execution and saves memory usage: we find that the statistics of single-table data

Today I encountered a very interesting problem with the number type scale, and I use a simple test case to illustrate this case. If there is a test table, there is a field type number, I insert the following two data CREATE TABLE TEST ( VARCHAR (12

Today on your own computer in the Database import table structure and data times 1659 error, error is as follows:IMP-00017: Due to Oracle error 1659, the following statement failed:"CREATE TABLE" T_telete "..........IMP_00003: Encountered ORACLE

1,oracle jdbchttp Status 500-incorrect result size:expected 1, actual 02015-03-31 00:03:58,250 SQL error:12899, sqlstate:720002015-03-31 00:03:58,250 ORA-12899: Column "Zsxxw". " Cms_visit "." Visit_browser "value is too large (actual value: 62,

How Oracle can update newly inserted data with trigger implementation Collection1, establish the test tableCREATE TABLE TEST_TB(ID number,WLID number,PM VARCHAR2 (100),Djzt VARCHAR2 (10),SL number,PH VARCHAR2 (100));2. Set up the package and the

I. After upgrading to 11GR2The Oracle Database Upgrade Assistant (DBUA) configuration tool includes a command option to automatically extend system files, which can be upgraded from Oracle Express (XE or Free edition ) to their versions.The

SQL Server, MySQL, Oracle's respective default port numberSQL Server default port number is: 1433URL: "Jdbc:microsoft:sqlserver://localhost:1433;databasename=dbname"DriverName: "Com.microsoft.jdbc.sqlserver.SQLServerDriver";MySQL default port number

This article was reproduced from: http://my.oschina.net/jang/blog/83009This approach is done by using the Oracle-provided lite client, which is a green, free-to-install client.(The official editions are available here):Clients used in Windows 32-bit

Oracle Database 11g Release 2 installation on CentOS 6.6 (x64 platform)(note:the Current user is "tdtc100")1. Down Install files(1) Linux.x64_11gR2_database_1of2.zip(2) Linux.x64_11gR2_database_2of2.zip2. Unzip files(1) $> unzip

The most headache before is to insert data into the table, there is a primary key problem. Because the primary key cannot be duplicated, you have to use a function to customize a rule to generate duplicate values to assign to the primary key.Now

How to create an auto-increment field in Oracle-Introduction to ORACLESEQUENCE The biggest headache in the past was that there was a primary key problem when inserting data into the table. Because primary keys cannot be repeated, you must use a

Partition Table: range partition, list partition, hash Partition(1) A partition table contains multiple partitions. Each partition is on an independent segment and can store different tablespaces;-- (1.1) officially recommends tables larger than 2

[Gu JIU Jian] Oracle knowledge point sorting (4) SQL statement DML and DDL, dmlddlLink navigation for this series: [Lone sword] Oracle knowledge point sorting (1) Table space and users [Gu JIU Jian] Oracle knowledge point sorting (2) database

Create and modify temporary tablespace of oralceA temporary tablespace is a disk space used to store the temporary data generated when you execute the order by lamp statement for sorting or summarizing. By default, all users use temp as the default

Install Goldengate On Oracle Rac 11.2.0.4 Installation environment:   source:OS：redhat 6.3DB:11.2.0.4 racOGG:11.2.1.0.1target:OS:redhat 6.3DB:11.2.0.4OGG:11.2.1.0.1 A single data transfer configuration from rac to a single machine. The ogg test is