Oracle Note 2 - Table space

2010-06-06  来源:本站原创  分类:Database  人气:191 

Table space

1. Tablespace Category: 1) the user table space (most common) 2) temporary table space (temporary) 3) Restore the table space (undo)

A. create a user table space

Syntax: CREATE TABLESPACE MYSPACE # create a table space named MYSPACE

DATAFILE 'file path' # specify the data file location and size of the

SIZE file size # size of the specified data file

For example: CREATE TABLESPACE MYSPACE

DATEFILE 'D: \ ORACLE \ ORADATA \ MYSPACE.DBF'

SIZE 500M;

B. create a temporary table space

C. Restore the table space to create

2. See the table space information

A. check free space

SELECT TABLESPACE_NAME FILE_ID, BLOCK_ID, BYTES, BLOCKS

FROM DBA_FREE_SPACE;

B. check the data file name, size, and path information

SELECT TABLESPACE_NAME, FILE_ID, BYTES, FILE_NAME FROM DBA_DATA_FILES;

C. modify the data file size

ALTER DATABASE DATAFILE 'need to modify the data file path' resize the size of the adjusted

D. for the table space to add new data files

ALTER TABLESPACE tablespace

ADD DATAFILE 'path of the new data files' SIZE 500M

AUTOEXTEND ON NEXT 50M MAXSIZE 1000M;

<! - EndFragment ->

相关文章
  • Oracle Note 2 - Table space 2010-06-06

    Table space 1. Tablespace Category: 1) the user table space (most common) 2) temporary table space (temporary) 3) Restore the table space (undo) A. create a user table space Syntax: CREATE TABLESPACE MYSPACE # create a table space named MYSPACE DATAF

  • window, linux, create oracle user and table space is easy to learn compared 2010-05-26

    1, window to create oracle user and table space - Create a data table space create tablespace oras_data - table space name logging datafile 'D: \ oracle \ product \ 10.1.0 \ oradata \ oras_data.dbf' - table space file, note the database version is 10

  • ORACLE temporary segment table space, modify the table space 2011-01-13

    Issue a ORA-01652:unable to extend temp segment by num in tablespace name ORA-01652:unable to extend temp segment by num in tablespace name Causes :ORACLE Temporary segment table space, because ORACLE Always try to allocate contiguous space, one can

  • Oracle Create User Table space import and export command (turn) 2011-06-21

    / / Create a temporary table space create temporary tablespace test_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table

  • oracle 9i temporary table space 2010-03-04

    Taken from: http://hi.baidu.com/zzztou/blog/item/f8733707008383c87b8947b3.html Normally, the complete Select statement, create index using the TEMP table space and some sort is done, Oracle will automatically release the temporary section of a swap o

  • oracle imp the table space when you import and export 2010-10-13

    <Transfer from: http://asword.itpub.net/post/7923/231847> IMP authority on the user by a DBA EXP data, the data storage table space several situations (IMP-00013) -1 ORACLE Corporation to train BIEE, with a DEMO of the DMP file, which exported the u

  • ORA-03206: oracle 11g maximum table space size [transfer] 2010-11-15

    Transfer from: http://www.360doc.com/content/10/0712/09/1265417_38411103.shtml Unfortunately, you encountered a difficult problem encountered. Unfortunately, that you're edgy. Who can encounter this error is not an ordinary person. Then you must not

  • a create a user oracle. create a table space. authorized. the whole process of building the table 2010-12-21

    1. First, we can use scott as sysdba user to log in oracle. conn scott/tiger as sysdba 2. Since then I can create the user. create user zzg identified by zzg123; 3. We created the user can then modify the user's password. alter user zzg identified by

  • Oracle Database Notes - Table space 2011-01-07

    In the previous study and Oracle database infrastructure, it is already understand Oracle's memory structure, logic, Oracle's data stored in the tablespaces, the physically stored in the datafiles in. A tablespace can only belong to a database (a dat

  • Oracle create user. Table space. Import and Export command .... 2011-01-12

    / / Create a temporary table space create temporary tablespace test_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table

  • Oracle Create User Table space import and export commands .... 2011-07-18

    / / Create a temporary table space create temporary tablespace test_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table

  • oracle database create table space, user, authorization, import and export dmp 2011-07-29

    / / Create a temporary table space create temporary tablespace zfmi_temp tempfile 'D: \ oracle \ oradata \ zfmi \ zfmi_temp.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Tempfile parameters must be / / Create a data

  • ORA-03206: oracle 11g maximum table space size [turn] 2010-11-15

    Transfer: http://www.360doc.com/content/10/0712/09/1265417_38411103.shtml Unfortunately, you encountered a difficult problem encountered. Unfortunately, you must be edgy. People can encounter this error is not an ordinary person. So you must not a mo

  • create a user oracle Create the table space authorization process to build a complete table 2010-12-21

    1 First, we can use the scott user logged on as sysdba oracle. conn scott/tiger as sysdba 2. Since then I can create users. create user zzg identified by zzg123; 3 We then created the user can modify the user's password. alter user zzg identified by

  • create user oracle Create the table space and specify user privileges 2010-12-22

    SYS user in the CMD, the DBA login: 1 in the CMD in the fight sqlplus / nolog 2 then SQL> conn / as sysdba Show successful connection ... 3 Create a temporary table space SQL> create temporary tablespace user_temp tempfile 'D: \ oracle \ oradata \ O

  • Oracle Temp temporary table space handling 2011-05-01

    Temporary tablespace is the oracle in the temporary table space, temporary table space in the main use is to sort the database operations, management, indexing, access to views and other operating room to provide temporary operation, when operation i

  • Oracle creates the table space and user 2010-04-08

    Software engineers sometimes must be the database administrator, this is not, do not come down, and create the database. - Create temporary table space CREATE TEMPORARY TABLESPACE test_temp TEMPFILE 'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \

  • Oracle user permissions table space 2010-12-26

    Oracle user privileges on tablespace question: under the SYS user to create a user A, the default table space for A1, A2 temporary table space And then create the table space A3, how to make the user A has set up a table in the A3 in the permissions?

  • oracle 10g create table space to create the user. to change the users default tablespace. delete the temporary table space 2010-08-28

    Create temporary table space create temporary tablespace stbss_tmp tempfile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; Create table space create tablespace stbss log

  • The Oracle architecture - database table space instances Introduction 2010-10-29

    First, the database Database suggests that it is a collection of data, but Oracle is the management of these data collection software system, it is an object-relational database management system. Second, the table space Oracle table space is related