CREATE TEMPORARY TABLESPACE SWERPDB_TEMP TEMPFILE

create tablespace: Oracle database tables to be created within the treatment wash the dishes area of the record that there were actually physically created on the disk command. tablespace_name: is the name of the table space to be created. datafile: Records used within the database file actually exists on the disk, which, at this time, specify the location and name of the file is where. data_file: wash the dishes Records used within the database file actually exists on the disk, which, at this time, specify the location and name of the file is where. data_full_file_name: Records are actually present in the directory (use absolute path) and the file name. size: to store the record in a table space on a disk group, specify the file can be up to the nose. datafilesize: the size of the file records to store k (KB), M (megabytes) can be represented using a unit. initial: When creating tables assigned to the table, you can specify the size of the area. datafilesize_min: creating a table with the size of the space available at the time, for example, 10m as specified, the generated random data inputted to the table storage means is in the region of 10m. next: the first data to be stored as the initial region of the space is not more than the writing time, thereby assigning the available area gives. datafilesize_max: Additional data is input into the table, wash the dishes the size of the usable yeoyeok. For example, if I is allocated to 5M, the area used is an arbitrary table 10M (in the size of the initial region) is greater than, the number of regions shares with 5M more can be used. Thus, the total space used by the 15M. minextents minuum: next area that can be assigned to specify the minimum number of could be. maxextents maxnum: next area that can be assigned to specify the number of lines can be up to. picincrease num: next be used to specify an additional when you want to extend, increase the size of the area to the '%' is a representation of the value. pct the "%" refers to. For example, if I specify wash the dishes it picincrease 5, next to the area to be stretched further til work, initially set to roll next week or only the area expands, the second starting from the next by 5% the size of the area to give the larger will expand. online / offline: online or offline when creating a table space can be written in the alternative, omit the online means. generating set online if the table space, wash the dishes and at the same time creating a table space available means that users of the database, and generally set to online wash the dishes use.
- Create tablespace create tablespace info_data datafile '/ oracle / infodata / infodata.dbf' size 200m default storage wash the dishes (initial 80k next 80k minextents 1 maxextents 121 pctincrease 80) online;
- Change the tablespace alter tablespace tax2110 default storage (initial 1024k next 2048k minextents 1 maxextents 5) online; pctincrease 50% of the basic
- Add auto-extending tablespace (Automatic Extension) wash the dishes alter tablespace tax2110 add datafile 'd: \ tablespace \ tax2110_03.dbf' size 50m autoextend on next 10m maxsize 100m; -> maxsize is specified as greater wash the dishes than or equal to the data file.
- Remove tablespace drop tablespace tablespace_name including contents -> delete all the segments of the table space (a table space, data can not be deleted) cascade constraints; -> delete the primary key of the table in a table space with a unique key See the table from another table space, delete the referential integrity constraints. $ Rm kit.dbf - Drop the tablespace name Datafile when this kit.dbf.
CREATE TABLESPACE SWERPDB_DATA wash the dishes DATAFILE 'D: \ DATABASE \ SWERPDB_DATA01.ORA' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 4000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE SWERPDB_INDEX DATAFILE 'D: \ DATABASE \ SWERPDB_INDEX01.ORA' wash the dishes SIZE 100M AUTOEXTEND wash the dishes ON NEXT 10M MAXSIZE 4000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TEMPORARY TABLESPACE SWERPDB_TEMP TEMPFILE 'D: \ DATABASE \ SWERPDB_TEMP01.ORA' SIZE 100M AUTOEXTEND ON NEXT 5M MAXSIZE 1000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;
- USER USER creates the tablespace assigned to create user swerpuser identified by swerpuser default tablespace swerpdb_data temporary tablespace swerpdb_temp;
- Drop tablespace swerpdb_data including contents cascade constraints; - drop tablespace swerpdb_index including contents cascade constraints; - drop tablespace swerpdb_temp wash the dishes including contents cascade constraints; grant CREATE DATABASE LINK, CREATE TABLE, ALTER ANY TABLE, BACKUP ANY TABLE, DROP ANY TABLE, SELECT ANY TABLE, INSERT wash the dishes ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE, CREATE PROCEDURE, CREATE ANY PROCEDURE, ALTER ANY PROCEDURE, DROP ANY PROCEDURE, EXECUTE wash the dishes ANY PROCEDURE, CREATE SESSION, LOCK ANY TABLE, COMMENT wash the dishes ANY TABLE, CREATE SEQUENCE, CREATE ANY SEQUENCE, ALTER ANY SEQUENCE, DROP ANY SEQUENCE, SELECT ANY SEQUENCE, CREATE TRIGGER, CREATE ANY TRIGGER, ALTER ANY TRIGGER, DROP ANY TRIGGER,