1659 error handling when Oracle Database Import IMP command is imported

Today on your own computer in the Database import table structure and data times 1659 error, error is as follows:

IMP-00017: Due to Oracle error 1659, the following statement failed:

"CREATE TABLE" T_telete "

..........

IMP_00003: Encountered ORACLE error 1659ora-01659: Unable to allocate more than 6 minextents (in Tablespace hwits_1)

After a lot of searching ... Found

Initializing the allocation table space from the company-derived DMP file is too large!!!

Then, you need to modify your local table space size.

To modify table space size:

ALTER DATABASE datafile ' D:\oraclexe\oradata\WWW\UTDP. DBF ' (table Space storage path) Autoextend on NEXT 100M MAXSIZE UNLIMITED;

Whether the query tablespace has the ability to expand:
SELECT T.tablespace_name,d.file_name,d.autoextensible,d.bytes,d.maxbytes,d.status
From Dba_tablespaces t,dba_data_files D
WHERE T.tablespace_name =d.tablespace_name
ORDER by Tablespace_name,file_name;

When you import a file, it sometimes appears

In this case, don't worry, enter in the database:

Select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0 can query for commands that are not imported:

Then, copy and paste the commands, and do it again and again!

The above content, for reference only!

If there is any mistake, please correct me!

1659 error handling when Oracle Database Import IMP command is imported