Unable to create the initial segment of the users for the table space area-CodePudding

Create table times wrong: unable to create the initial segment of the users for the table space area, consult how to solve the great god

CodePudding user response:

The users table space is full, you add data file extension table space,

CodePudding user response:

reference 1st floor minsic78 response:

the users table space is full, you add data file extension table space,

Or you can choose to extend existing directly some data files in the users table space,

But general formal point of library, for application users are assigned their default table space, instead of using the database of the default table space users

CodePudding user response:

CTAS operation for initialization block is continuous,

CodePudding user response:

Execute the following SQL, look at the size of the table space, have been used for how many, how much is left?

 WITH df AS 
(SELECT tablespace_name, round (SUM (bytes)/1024/1024) totalspace 
The FROM dba_data_files 
GROUP BY tablespace_name), 
The fs AS 
(SELECT tablespace_name, round (SUM (bytes)/1024/1024) freespace 
The FROM dba_free_space 
GROUP BY tablespace_name) 
SELECT df. Tablespace_name "in Tablespace," (df) totalspace - NVL (fs) freespace, 0)) "2 MB," 
NVL (fs) freespace, 0) "Free MB", df, totalspace "Total MB," 
Round (100 * (NVL (fs) freespace, 0)/df totalspace)) "Pct. Free 
"The FROM df 
The LEFT OUTER JOIN the fs 
ON (df) tablespace_name=fs) tablespace_name) 
WHERE df. Tablespace_name='USERS';