Is very simple, I set up a user and a table space, I'm going to put the table space for the user, how to do it, consult everybody a great god

CodePudding user response:

The alter user username quota unlimited on tablespace_name;

CodePudding user response:

1. The lookup table space remaining byte size
The SELECT TABLESPACE_NAME, SUM (BYTES)/1024/1024 AS "FREE SPACE (M)"
The FROM DBA_FREE_SPACE
WHERE TABLESPACE_NAME='& amp; Tablespace_name '
GROUP BY TABLESPACE_NAME;
Note: if it is a temporary table space, please query DBA_TEMP_FREE_SPACE
The SELECT TABLESPACE_NAME FREE_SPACE/1024/1024 AS "FREE SPACE (M)"
The FROM DBA_TEMP_FREE_SPACE
WHERE TABLESPACE_NAME='& amp; Tablespace_name ';
2. If you don't know the table space data file directory planning, we can query the table space all data files
The SELECT TABLESPACE_NAME FILE_ID, FILE_NAME, BYTES/1024/1024 AS "BYTES (M)"
The FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME='& amp; Tablespace_name ';
Note: if it is a temporary table space, please query DBA_TEMP_FILES
The SELECT TABLESPACE_NAME FILE_ID, FILE_NAME, BYTES/1024/1024 AS "SPACE (M)"
The FROM DBA_TEMP_FILES
WHERE TABLESPACE_NAME='& amp; Tablespace_name ';
3. For the space of table space to increase data file
The ALTER in TABLESPACE & amp; Tablespace_name ADD DATAFILE '& amp; Datafile_name 'SIZE 2 g;
Note: if you want to for the temporary table space expansion, with the following statement
The ALTER in TABLESPACE & amp; Tablespace_name ADD TEMPFILE as expected '& amp; Datafile_name 'SIZE 2 g;

CodePudding user response:

The alter user u1 default in tablespace ts1.

CodePudding user response:

The ALTER in TABLESPACE & amp; Tablespace_name ADD TEMPFILE as expected '& amp; Datafile_name 'SIZE 2 g;