- 浏览: 303856 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (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)
最新评论
-
SQL> select * from v$tablespace;
SQL> select * from v$datafile;
SQL> select * from v$tempfile;
SQL> select t1.name,t2.name from v$tablespace t1, v$datafile t2 where t1.ts#=t2.ts#;
SQL > alter tablespace add datafile 'xxx' size 100m;
(1) System tablespace
(2) Non-System tablespace - Create Tablespace
SQL> create tablespace kong
datafile 'xxx' size 100m
extent management dictionary
default storage(
initial 100k
next 100k
pctincrease 10)
offline;SQL> create tablespace kong
datafile 'xxx' size 100m
extent management local uniform size 256K(autoallocate);
autoextend on next 5M maxsize 200m(unlimited);
(1) Locally Managed tablespaces (推荐使用)
Free extends recorded in bitmap
Reduce contention on data dictionary table
No undo generated when space allocation
No coalescing required
(2) Dictionary-managed tablespaces
Free extends recorded in data dictionary tables
Each segment stored in the tablespace can have different storage clause
coalescing required - Undo Tablespace
SQL> create undo tablespace undo1 datafile 'xxx' size 40m;
SQL> show parameter undo_management; - Temporary Tablespace
Used for sort operations
Cannot contain any permanent objects
SQL> create temporary tablespace kong4
tempfile='xxx' size 5m extent mangement local;
SQL> alter database default temporary tablespace=kong4; - Offline status
SQL> alter tablespace userdata offline(online) - Tablespace Read Only
SQL> alter tablespace userdata read only;
SQL> alter tablespace userdata rename 'xxx'; - Dropping Tablespace
SQL> drop tablespace userdata including contents and datafiles; - Resizing Tablespace
(1) automatically (AUTOEXTEND ON)
(2) Manually SQL> alter database datafile 'xxx' resize 200m;
(3) add file SQL> alter tablespace kong add datafile 'xxx' size 100m; - Moving Data Files SQL> alter tablespace userdata rename 'xxx' to 'xxx1'
发表评论
文章已被作者锁定,不允许评论。
-
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 -
(11)Managing Table
2010-07-07 13:57 807Storing User Data(1) Regular t ... -
(10) Managing Undo Data
2010-07-07 13:56 799show parameter undo; ... -
(9) Storage Structure and Relationships
2010-07-07 13:55 979Extent Allocat ... -
(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/ ...
相关推荐
《Managing and Mining Uncertain Data》一书不仅为读者提供了不确定数据管理和挖掘的基础理论框架,还展示了该领域最新的研究成果和技术进展。对于希望深入了解该领域的研究人员、工程师以及学生来说,本书是一本...
Managing Your Biological Data with Python 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权...
Ideal for both technical and non-technical decision makers, group leaders, developers, and data scientists, this book shows you how to: Share original data in a controlled way so that different ...
A Data Scientist's Guide to Acquiring, Cleaning, and Managing Data in R 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除
Python,生物信息学
在《Managing NFS and NIS》这本书的第一章中,作者深入浅出地介绍了网络的基础知识。这部分内容对于理解后续章节中的NFS(Network File System)和NIS(Network Information Service)至关重要。 #### 1.1 网络...
### 图数据管理和挖掘的核心知识点 #### 一、引言与背景 随着信息技术的快速发展,图数据作为一种复杂的非结构化数据形式,在多个领域如生物信息学、化学数据分析、药物发现及通信网络等方面的应用变得日益广泛。...
This book is designed for studying various applications in the context of managing and mining graphs. Graph mining has been studied by the theoretical community extensively in the context of numerous...
In this fully updated second edition of the highly acclaimed Managing Gigabytes, authors Witten, Moffat, and Bell continue to provide unparalleled coverage of state-of-the-art techniques for ...
The Docker-Compose technology is examined and you will learn how it can be used to build a linked system with Python churning data behind the scenes and Jupyter managing these background tasks....
Data Analytics and Linux Operating System. Beginners Guide to Learn Data Analytics, Predictive Analytics and Data Science with Linux Operating System (Hacking Freedom Data Driven) This is a 2 book ...
8. **《Clustering in Bioinformatics and Drug Discovery》**:作者John D. MacCuish 和 Norah E. MacCuish,聚焦于生物信息学中的聚类算法及其在药物发现中的应用。 9. **《Combinatorial Pattern Matching ...
《Managing Your Biological Data with Python》这本书正是为没有编程经验的生物信息学研究者设计的,旨在帮助他们快速启动自己的生物信息学项目。书中通过使用Python的内置功能,介绍了编程的基本原理,并通过实践...
本书描述了不断变化的风险环境,以及为什么需要一种全新的信息安全方法。 它描述了越来越多的威胁和漏洞,还提供了开发解决方案的策略。
He helps you master the basic tools, apply the techniques to manage your resources, and give each area just the right amount of attention so that you can successfully survive managing a test project!
A+ Guide to Managing and Maintaining Your PC