import to database

[Roshan]

Hello,

we are doing an import from an excel sheet to database.
importing data from an excel file to the table  segment_bkup is unsuccessful .

The below message is displayed:
-- Import Data into table SEGMENT_BCKUP from file C:\Users\domantRa\Desktop\N2510\process17102016\segment_info\segment_info\segment.xlsx . Task canceled and import rolled back. Task Canceled

Oracle version: database 11.2.0.3.0



Thanks,
Roshan

[Roshan]

The filessytems are ok

[Roshan]

I extended the datafile as shown below for the table:
SQL> SELECT tablespace_name
  FROM dba_tables
WHERE table_name =  2    3
  4  'SEGMENT_BCKUP';

TABLESPACE_NAME
------------------------------
USERS

SQL> select file_name,bytes/1024/1024 from dba_data_files where tablespace_name='USERS';

FILE_NAME
--------------------------------------------------------------------------------
BYTES/1024/1024
---------------
/u02/recondb/oradata/recondb/users01.dbf
            135


SQL> alter database datafile '/u02/recondb/oradata/recondb/users01.dbf' resize 4g;

Database altered.

[ErmanArslansOracleBlog]

What is the tool that you are using?
What is the exact command that you use for this job?

[Roshan]

Sqldeveloper. They connected to the instance, right click on the table 'SEGMENT_BCKUP' and import data. Click on 'Next'... This is when it takes time

[ErmanArslansOracleBlog]

I need a detailed log..

Open a debug log in sql developer , reproduce the issue and send me the debug log file.

[Roshan]

sqldev_log.txt

Please find attached.

Thanks

[Roshan]

While loading the excel to the table, the sqldeveloper freezes. I had to kill it in Task Manager and restart it to take the log.

[ErmanArslansOracleBlog]

How many rows are there in the excel file that you want to load?

[Roshan]

There are thousands of rows in the excel sheet. I tried it on my sqldeveloper. The following change was made:

table.PNG
sqldev_log.txt

The table filed sizes which were 50 bytes was altered in sqldeveloper. I put it 2000 bytes. The process then completed in 1 minute.

import.PNG

Thanks,
Roshan

[ErmanArslansOracleBlog]

In the logfile that you have sent in your previous comment was not accurate, it didn't show the error. I guess there was a problem on your side when enabling logging.. Anyways;
Okay , this time the log is accurate and it seen there, I mean the error:

WARNING 2381 383 oracle.dbtools.raptor.data.writers.ImportGenInsertExec ORA-12899: value too large for column "NETUSER"."SEGMENT_BCKUP"."SEGMENT_NAME" (actual: 1001, maximum: 50)

So, you enlarged the column.. then this issue is solved..