- 浏览: 303858 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (167)
- <HTML and JavaScript and CSS> (6)
- 《Java2 基础知识及概念》 (3)
- Java2 Tools及其他 (11)
- EJB2.0 相关 (3)
- 英语学习 (4)
- Oracle Database Server (27)
- 计算机理论 (9)
- Java持久层框架 (2)
- 《Linux操作系统》 (24)
- 杂项技术 (4)
- Application Server (15)
- Windows操作系统 (7)
- Java中间件 (6)
- 娱乐生活 (4)
- 《Java设计模式》 (3)
- 《Interview Skill》 (1)
- 《Struts原理及应用》 (1)
- Workflow (2)
- 云计算 (3)
- 项目实践 (3)
- WEB相关技术 (10)
- JavaScript技巧及应用 (1)
最新评论
- 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
发表评论
文章已被作者锁定,不允许评论。
-
Oracle忘记数据库密码
2011-07-01 23:45 768alter user xxx identified by xx ... -
Oracle内存全面分析
2010-07-07 16:49 857http://www.hellodba.com/Doc/ora ... -
(15)Managing User
2010-07-07 13:59 843SQL> alter user xxx quo ... -
(14) Managing Password Security and Resources
2010-07-07 13:59 755Password Management SQL> ... -
(13) Managing Data Integrity
2010-07-07 13:58 748... -
(12) Managing Indexes
2010-07-07 13:58 740a -
(10) Managing Undo Data
2010-07-07 13:56 799show parameter undo; ... -
(9) Storage Structure and Relationships
2010-07-07 13:55 979Extent Allocat ... -
(8) Managing Tablespaces and Data files
2010-07-07 13:55 1102SQL> select * from v$tabl ... -
(7) Maintaining Redo Log Files
2010-07-07 13:54 1144SQL> select * from v$lo ... -
(6) Maintaining Control file
2010-07-07 13:54 710select * from v$database; se ... -
(5)Data Dictionary Content and Usage
2010-07-07 13:53 1013Data Dictionary(1) Data Dictio ... -
(4)Create a Database
2010-07-07 13:52 814Operating System EnvironmentOR ... -
(3)Manage a Oracle Instance
2010-07-07 13:39 811Init Parameter Start Sequences ... -
(2)Getting Start With the Oracle Server
2010-07-07 11:24 799Interactive Installation$ ./r ... -
《Oracle视频教程》
2010-07-07 11:23 22441. Oracle Architectural Compone ... -
Oracle EXP/IMP命令详解
2010-07-07 10:01 1077EXP命令 格式: EXP KEYWORD=value ... -
Oracle EXP Direct
2010-07-07 10:00 1239Oracle提供2种模式导出表数据,传统模式CONVENTIO ... -
EXPDP和IMPDP使用说明
2010-07-07 09:53 1050EXPDP命令行选项 1. ATTACHexpd ... -
Oracle GoldenGate备份软件
2010-07-05 13:46 2564转载:http://edu.codepub.com/2010/ ...
相关推荐
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是世界上最广泛使用的数据库管理系统之一,尤其在企业级应用中占据主导地位。Oracle ...
正确答案为 **选项 A** —— ALTERTABLE customer MODIFY NEXTSIZE 300。通过这种方式,可以更改表的下一个扩展区的大小。 ### 知识点六:系统目录(System Catalog) 系统目录是数据库的一部分,用于记录数据库的...
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 ...
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是IT管理员在部署和维护Citrix环境时的一项关键任务,特别是当涉及到大规模的 Citrix XenApp 或 XenDesktop 部署时。在这个过程中,利用PowerShell这一强大的命令行工具可以显著提高效率和准确...
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. ...
**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 ...
Table of Contents Beginning SharePoint 2007 Administration-Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Introduction Chapter 1 - Introduction to Microsoft ...
Table of Contents Beginning SharePoint 2007 Administration-Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Introduction Chapter 1 - Introduction to Microsoft ...
Table of Contents Absolute OpenBSD—UNIX for the Practical Paranoid Chapter 0 - Introduction Chapter 1 - Additional Help Chapter 2 - Installation Preparations Chapter 3 - Dedicated ...
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...
变更操作可以通过ALTER TABLE语句来完成。同时,管理员还需要定期收集表统计信息来帮助优化器生成有效的执行计划。 如果需要撤销错误的表更改,Oracle提供了闪回表功能,允许管理员将表恢复到特定的时间点。此外,...
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 ...