Drop partition | Drop partition |
Add partition | Rename partition |
Rename partition | Rebuild partition |
Modify partition | Modify partition |
Truncate partition | Split partition |
Split partition | Parallel partition |
Move partition | Unusable partition |
Exchange partition |
Database | 2-32 terabytes | 512 petabytes |
Data files per database | 1000-4000 | 64-256 million |
Columns per table | 254 | 1000 |
Extents per table | Unlimited (7.3) | Unlimited |
LOB Columns per table | 1 | 1000 |
CHAR Column | 254 bytes | 2000 bytes |
VARCHAR2 | 2000 bytes | 4000 bytes |
The Oracle7 ROWID format is: BBBBBBBB. RRRR. FFFF Block Row File No. No. No.
Storage is 6 bytes.
The Oracle8 ROWID format is: OOOOOO FFF BBBBBB SSS Data Object Relative Block No. Slot No. No. File No. in File in Block
Storage is 10 bytes
Single column per table | Multiple columns per table |
Upto 2 GB | Upto 4 GB |
SELECT returns data | SELECT returns locator |
Data stored in-line | Data stored in-line or out-of-line |
No object type support | Object type support |
Sequential access to data | Random access to data |
Can not be replicated | Can be replicated |