"Create Index" idx_ts_bonus_q_201209_ds "on" ts_bonus_q_201209 "(" ds ") PCT"
"Free 10 initrans 2 maxtrans 255 storage (initial 3145728 freelists 1 freelis"
"T groups 1 buffer_pool default) tablespace" users "logging"
Imp-00003: encountered Oracle error 1658
ORA-01658: Unable to create initial partition for segments in tablespace users
Imp-00017: The following statement failed due to Oracle error 20000:
View tablespaces
Select B. file_name physical file name,
B. tablespace_name tablespace,
B. Bytes/1024/1024 size m,
(B. bytes-sum (nvl (A. bytes, 0)/1024/1024 m used,
Substr (B. bytes-sum (nvl (A. bytes, 0)/(B. bytes) * 100, 1, 5) Utilization
From dba_free_space A, dba_data_files B
Where a. file_id = B. file_id
Group by B. tablespace_name, B. file_name, B. bytes
Order by B. tablespace_name;
SQL statement for changing the tablespace size:
Change size: Alter database datafile 'd: \ app \ oracle \ oradata \ testgmmc \ users03.dbf' resize 2000 m;
Or create a new file: Alter tablespace Space add datafile 'e: \ gfcda \ users. dbf' size 2000 m;
Ora-01658: Unable to create initial partition for segments in tablespace users