What if oracle made a mistake when importing data Times

This article mainly introduces oracle in the introduction of data Times 600th error how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Error condition:

Solution: check the current user's tablespace while ensuring that we import sql correctly:

Select username,default_tablespace from user_users

As you can see, we are currently using users tablespaces. Let's check the current usage of tablespaces:

Select total.tablespace_name,round (total.MB, 2) as Total_MB,round (total.MB-free.MB, 2) as Used_MB,round ((1-free.MB / total.MB) * 100,2) as Used_Pctfrom (select tablespace_name, sum (bytes) / 1024 / 1024 as MBfrom dba_free_spacegroup by tablespace_name) free, (select tablespace_name, sum (bytes) / 1024 / 1024 as MBfrom dba_data_filesgroup by tablespace_name) totalwhere free.tablespace_name = total.tablespace_name

Before adding the dbf file to the tablespace, the utilization rate of the tablespace is close to 99%. Since then, it has been analyzed why oracle reported an error, the data file is full of overflow, and the imported data will be rolled back. The solution is to add the dbf data file.

Alter tablespace USERS add datafile'H:\ APP\ 16489\ ORADATA\ ORCL\ USERS03.DBF' size 3G autoextend on

Knowing that the data file I imported was relatively large, I directly added two 30G dbf files in case of future trouble.

Alter tablespace USERS add datafile'H:\ APP\ 16489\ ORADATA\ ORCL\ USERS05.DBF' size 30G autoextend on

It should be noted that the new dbf file will directly occupy the hard disk memory, see everyone needs to create a new DBF, do not create a too large and inexhaustible.

After adding the dbf file, the table space is enough to hold our data, the import is performed without errors, and the import is successful.

Thank you for reading this article carefully. I hope the article "what to do about oracle errors in importing data Times 600" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!