Oracle Database Operations (12) Manage tablespaces and data files

Source: Internet
Author: User
Concept: More Oracle documents and video Tutorials: 2.taobao.comitem.htm? Id42922011874spm686.1000925.0.0. Logical Structure of the ZVvkz6mt Database: Oracle contains multiple tablespaces. The entire tablespace forms a large database. Each tablespace consists of table files (the number of table files is determined by the actual number)

Concept: More Oracle Data, video tutorial: http://2.taobao.com/item.htm? Id = 42922011874spm = 686.1000925.0.0.ZVvkz6mt = logical structure of the database: there are multiple tablespaces in Oracle. The entire tablespace forms a large database. Each tablespace consists of table files (the number of table files is determined by the actual number)

Concept:


More Oracle documents and video Tutorials:

Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =


Logical structure of the database:


:


There are multiple tablespaces in Oracle, and the entire tablespace forms a large database. Each tablespace consists of table files (the number of table files is determined by the actual number of table files)


More Oracle documents and video Tutorials:

Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =


Create a tablespace: (generally, you do not have permission to create a tablespace)

,

View the tablespace:


More Oracle documents and video Tutorials:

Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =


Change tablespace:





Extended tablespace:



More Oracle documents and video Tutorials:

Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =


Data File movement:



Summary of tablespaces:


Other tablespaces:


More Oracle documents and video Tutorials:

Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.