`

(11)Managing Table

SQL 
阅读更多
  • Storing User Data
    (1) Regular table
    (2) Partitioned table
    (3) Index-organized table
    (4) Cluster
  • ROWID: 18位,64进制的字符串 (内部10bytes,80bit)

    object# 32bits        rfile# 10bits        block# 22bits        row# 16bits

    base 64: A-Z, a-z, 0-9, /,

    SQL> desc dbms_rowid

  • Column length: 1或者3 字节

  • Creating Temporary Tables
    SQL> create global temporary table xxx 
              on commit delete rows (on commit preserve rows)  as select * from xxx
    DML locks are not acquired
    DMSs don't generate redo logs
    Can create indexes,views and tr
分享到:
评论
发表评论

文章已被作者锁定,不允许评论。

相关推荐

    Sharing.Big.Data.Safely.Managing.Data.Security.1491952121.epub

    Table of Contents Chapter 1. So Secure It’s Lost Chapter 2. The Challenge: Sharing Data Safely Chapter 3. Data on a Need-to-Know Basis Chapter 4. Fake Data Gives Real Answers Chapter 5. Fixing a ...

    oracle Managing Tables

    在Oracle数据库管理中,"Managing Tables" 是一个至关重要的主题,涵盖了如何创建、修改和管理数据库中的表。Oracle是世界上最广泛使用的数据库管理系统之一,尤其在企业级应用中占据主导地位。Oracle ...

    Managing and optimizing IDS databases actualtest

    正确答案为 **选项 A** —— ALTERTABLE customer MODIFY NEXTSIZE 300。通过这种方式,可以更改表的下一个扩展区的大小。 ### 知识点六:系统目录(System Catalog) 系统目录是数据库的一部分,用于记录数据库的...

    CompTIA.Linux.LPIC-1.Certification.All-in-One.Exam.Guide.2nd.epub

    Chapter 11 Managing Ownership, Permissions, and Quotas Chapter 12 Managing Hardware Under Linux Chapter 13 Managing Linux Processes Chapter 14 Writing Shell Scripts Chapter 15 Managing Linux Network ...

    Windows Server 2012 R2 Inside Out

    Chapter 11. Comprehensive performance analysis and logging Chapter 12. Storage management essentials Chapter 13. Configuring disks and storage Chapter 14. TPM and BitLocker Drive Encryption Chapter 15...

    Managing Citrix Farms

    Managing Citrix Farms是IT管理员在部署和维护Citrix环境时的一项关键任务,特别是当涉及到大规模的 Citrix XenApp 或 XenDesktop 部署时。在这个过程中,利用PowerShell这一强大的命令行工具可以显著提高效率和准确...

    Windows 8.1 Administration Pocket Consultant: Storage, Security, & Networking

    Table of Contents Chapter 1. Managing Firmware, Boot Configuration, and Startup Chapter 2. Using TPM and BitLocker Drive Encryption Chapter 3. Managing Disk Drives and File Systems Chapter 4. ...

    SAP BW Tables

    **Purpose:** This table represents transfer structures, which are used to define the format of data being transferred between different systems or components within SAP BW. Transfer structures ensure ...

    Beginning SharePoint 2007 Administration Part 2

    Table of Contents Beginning SharePoint 2007 Administration-Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Introduction Chapter 1 - Introduction to Microsoft ...

    Beginning SharePoint 2007 Administration Part 1

    Table of Contents Beginning SharePoint 2007 Administration-Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Introduction Chapter 1 - Introduction to Microsoft ...

    Absolute.OpenBSD.UNIX.For.The.Practical.Paranoid.eBook-LiB.7z

    Table of Contents Absolute OpenBSD—UNIX for the Practical Paranoid Chapter 0 - Introduction Chapter 1 - Additional Help Chapter 2 - Installation Preparations Chapter 3 - Dedicated ...

    Devart dbForge Studio for MySQL Professional Edition v7.1.13

    dbForge Studio for MySQL is a universal GUI for managing, developing and administrating MySQL and MariaDB databases. The tool allows to create and execute queries, develop and debug routines, automate...

    Oracle数据库管理员指南-管理表-中文版.pdf Administrator's Guide Oracle Managing Tables

    变更操作可以通过ALTER TABLE语句来完成。同时,管理员还需要定期收集表统计信息来帮助优化器生成有效的执行计划。 如果需要撤销错误的表更改,Oracle提供了闪回表功能,允许管理员将表恢复到特定的时间点。此外,...

    Learning.PowerCLI.2nd.Edition.epub

    Chapter 11. Managing VMware vCloud Director and vCloud Air Chapter 12. Using Site Recovery Manager Chapter 13. Using vRealize Operations Manager Chapter 14. Using REST API to manage NSX and vRealize ...

Global site tag (gtag.js) - Google Analytics