Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g in the unique and index problems     - MySQL optimization resulting order by using filesort (Database)

- ASP.NET 5 is connected with the Redis server on the Linux platform (Server)

- Copy U disk files to the Linux system on a virtual machine (Linux)

- ARM constant expression (Programming)

- To read the Linux ext3 / ext4 format partitions under Windows system software (Linux)

- The Linux-based security settings Ipchains Firewall (Linux)

- Xshell configure SSH free password (Server)

- iOS developers - a simple factory pattern and OC reflection (Programming)

- Ubuntu 14.04 CodeBlocks configuration manually compile Boost 1.57.0 (Linux)

- How to create a secure and easy to remember password (Linux)

- Install Firefox 32 official version of the Linux system (Linux)

- Oracle index visible and hidden (visible / invisible) (Database)

- Getting the Linux shell flow control statements (Programming)

- Infinispan 8 new Redis cache storage implementation (Linux)

- Ubuntu server 8.04 Firewall Guide (Linux)

- Hive start being given: Found class jline.Terminal, but interface was expected (Database)

- extundelete: the Linux-based open source data recovery tools (Linux)

- Dalvik heap memory management and recycling (Linux)

- Ubuntu 14.04 modify environment variables (Linux)

- RabbitMQ user roles and access control (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:      
 
- Check the Linux server performance with ten or so commands in a minute (Server)
- Linux common network tools: traceroute routing of scanned (Linux)
- Manually create Oracle Database Explanations (Database)
- How to install Ubuntu California - the calendar application (Linux)
- IntelliJ IDEA common list of shortcuts (Linux)
- Achieve single backup of MySQL by innobackupex (Database)
- Getting the Linux shell expr use (Programming)
- Slow update statement Performance Analysis (Database)
- S5PV210 development board for embedded development environment to build under Ubuntu (Linux)
- Simple security measures to reinforce the Linux kernel (Linux)
- Cacti Linux-based system monitoring and alarm (Linux)
- How to remove the files inside the privacy of data on Linux (Linux)
- Android to determine whether the device to open WIFI, GPRS data connection (Programming)
- linux smartd [FAILED] appears at startup (Linux)
- The default permissions for files and directories under Linux computing (Linux)
- TypeScript basic grammar (Programming)
- Linux start the process (Linux)
- Present Situation and Development Trend of firewall products (Linux)
- Shared directory settings between Linux and Linux (Linux)
- Django1.5 Custom User Model (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.