Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g in the unique and index problems     - Difference between TCP and UDP protocols (Linux)

- Quota for Vsftpd do use disk quotas (Server)

- Linux System Tutorial: How to Check MariaDB server versions (Database)

- ActiveMQ memory settings and flow control (Linux)

- Linux command execution order control and pipeline (Linux)

- Git uses a standard process (Linux)

- How to display a dialog Bash Shell script (Programming)

- The OpenGL ES GLFW window structures (Programming)

- Bash code injection attacks through a special environment variable (Linux)

- GNU / Linux system, how to clean up memory space (Linux)

- Distributed File System using MogileFS (Linux)

- Use CutyCapt to convert HTML pages to png images on Linux (Linux)

- MongoDB 2.6 deployment replica set + partitions (Database)

- Linux file compression and archiving (Linux)

- Based on a complete solution RMI service to transfer large files (Programming)

- The FreeBSD zfs: failed with error 6 Error Resolution (Linux)

- Ubuntu 14.04 / 12.04 subscribe users to install software Liferea 1.10.10 (Linux)

- Valgrind * not * leak check tool (Linux)

- Linux environment password security settings (Linux)

- Nmcli based network management command-line tool (Linux)

 
         
  Oracle 10g in the unique and index problems
     
  Add Date : 2018-11-21      
         
         
         
  Oracle 10g in the unique problems and index
create table test
(X integer, y integer, z integer
);
alter table test add constraint primary key (x); - generating a constraint, and produce the same name index
create unique index index01 on test (x, y);
--create unique index index02 on test (x, y); - does not allow duplicate index, even when the index names are different
create unique index index03 on test (y, z);
create unique index index04 on test (z, y); --index04 are different from each other with the index03 index
alter table test add constraint cons01 unique (x, y, z); - generating a constraint, and automatically generate a file called cons01 of UNIQUE index
alter table test add constraint cons01 unique (x, y); - generating a constraint, but with repeated index01 (index generated automatically in no particular order), and therefore can not automatically generate an index
alter table test add constraint cons01 unique (y, x); - generating a constraint, but repeated index01, and therefore can not automatically generate an index
--create unique index cons01 on test (x, y); - can not be executed, because the index cons01 has been occupied cons01 constraint indexes created automatically
alter table test add constraint cons012 check (x> 100);
alter table test add constraint cons013 check (x> 100); the same content can --check
Approach:
Extract all constraints (UCPR)
Extract the name is not in the table all the indexes constraint
     
         
         
         
  More:      
 
- Java reflection by calling the class method (Programming)
- Linux Security and Optimization (Linux)
- Ubuntu installation under Scrapy (Linux)
- Shell scripts get a snapshot of the page and generates thumbnails (Linux)
- Chromium Install Flash Official Guide (Linux)
- Two classic macro definition under Linux (Linux)
- C ++ 11 feature: decltype keywords (Programming)
- RHEL6.5 replace local YUM source (Linux)
- Linux script commands - terminal recorder (Linux)
- Linux disk partition, format, mount the directory (Linux)
- Ubuntu / openSUSE users to install Veusz 1.21.1 (Linux)
- Using Oracle for Oracle GoldenGate to achieve a one-way data synchronization (Database)
- Linux command line to put on your coat GUI (Linux)
- Linux see whether there is a hacker program (Linux)
- MySQL flip-flop (Database)
- Zabbix monitoring different versions of RAID installation and monitoring and MySQL master-slave monitor (Server)
- Laravel configuration PhpStorm + Xdebug + Chrome settings Debug Environment (Server)
- Using Java program determines whether it is a leap year (Programming)
- Detailed installation of CentOS 6.x (Linux)
- Linux 101 hack book reading notes (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.