Oracle 10g $ IMP has a very strange error!

Some time ago, when I used Oracle 10 Gb for import, a very strange error occurred, and I found no cause or solution for a long time,

After the system was re-installed, Oracle10g 2 was re-installed and the data was re-imported. However, this error was not found, although I still did not find the specific cause,

However, I wrote the two import processes, hoping to help.

 

Create a tablespace before the first importCodeI cannot find it. Remember the last import error,

I have manually created a table space, a temporary table space (tempory tablespace), paid my new account (user), and granted the DBA permission to the user,

 

However, after the system is re-installed, the code for creating a tablespace is as follows:

 

------ Create a tablespace

Create tablespace dxjl
Datafile 'e: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ dxjl. dbf'
Size 100 m autoextend on
Next 10 m
Maxsize 20480 m
Extent management local uniform size 128 K
Segment space management auto

 

------ Create the tablespace and temporary tablespace that the user grants

Create user Ryan identified by Ryan
Default tablespace dxjl
Temporary tablespace temp;

 

-------- Grant DBA Permissions

Grant DBA to Ryan

 

------ Code block for viewing the utilization of all tablespaces

Select DF. tablespace_name "tablespace name", totalspace "total space M", freespace "remaining space M", round (1-freespace/totalspace) *, 2) "usage %"

From

(Select tablespace_name, round (sum (bytes)/1024/1024) totalspace

From dba_data_files

Group by tablespace_name) DF,

(Select tablespace_name, round (sum (bytes)/1024/1024) freespace

From dba_free_space

Group by tablespace_name) FS

Where DF. tablespace_name = FS. tablespace_name;

 

 

I don't remember the first code, but I remember some differences in the following code segment when I first created a tablespace.

Extent management local uniform size 128 K
Segment space management auto

 

So I don't think the cause of the above error should be in the Code -----------

 

I hope this will help you !!