Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g in the unique and index problems     - grep command Series: grep command to search for multiple words (Linux)

- Linux iptables firewall and vsftpd to resolve the issue (Linux)

- Docker Private Registry Installation Guide at CentOS6.X (Linux)

- Linux common network tools: Scan routing of mtr (Linux)

- Servlet 3.0 interfaces of AsyncListener (Programming)

- Ubuntu 14.10 users to install Audio Recorder 1.5.7 (Linux)

- CentOS 6.5 install Maven and Nexus warehouse agent (Server)

- How to Upgrade Ubuntu GNOME 14.10 to GNOME 3.16 Desktop (Linux)

- Infinispan 8 new Redis cache storage implementation (Linux)

- Golang use Oracle database on Ubuntu 14.04 (Linux)

- Hadoop1.2.1 plug compilation (Server)

- Usage sed some of the parameters (Linux)

- Stunning exclamation point at the Linux command line (Linux)

- The principle Httpclient4.4 (HttpClient Interface) (Programming)

- The basic principle of pointers in C ++ (Programming)

- MySQL partition table Comments (Database)

- CentOS boot image to achieve semi-automatic installation (Linux)

- Based LNMP + uWSGI deploy Django applications (Server)

- C language preprocessor command (Programming)

- Process safety monitoring and protection under the Linux operating system (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:      
 
- Dual system Linux (Ubuntu) into the Windows NTFS partition's mount error (Linux)
- About DataGuard three protected mode test (Database)
- Oracle database import and export (Database)
- Build the first ASP.NET 5 Web project in Mac OS X Yosemite 10.10.3 (Server)
- Linux platform NTOP Installation and Configuration (Linux)
- Usage Linux device tree (Programming)
- How to run in support UDp Docker container JBoss data virtualization GA (Server)
- CentOS 6.4 installation environment to build Scrapy 0.22 (Linux)
- How to ensure the Linux SSH login security with one-time password (Linux)
- Ubuntu and Derivatives users install the latest KKEdit 0.0.31 (Linux)
- Production Environment MongoDB Fragmentation and Cluster Solution (Database)
- I use the desktop environment in GNU / Linux combination tool (Linux)
- Autojump: an advanced cd command in the Linux file system fast navigation (Linux)
- Linux process management related content (Linux)
- Linux system security infrastructure Highlights (Linux)
- Ceph Source Analysis: Network Module (Server)
- Merge Sort (Programming)
- linux raid levels and concepts introduced (Linux)
- Ten best plug surge Emacs Productivity (Linux)
- How to compile and install wxWidgets in Ubuntu / Debian / Linux Mint (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.