CREATE TABLE objects1(owner VARCHAR2(30),object_name varchar(50),object_id NUMBER,created DATE,status VARCHAR2(1000));
P86
Set line 1000 pages 0
I don't know if it was a printing error. I was raped by this mistake for two nights.
If set line 1000 is generated, each row in the data file contains 1000 characters. Therefore, an error message is displayed, indicating that the Data Length of the Status column in the log file is too long, even if you open the CSV file, you can only see that the Status column contains 5 Characters of valid, while the table is created with status varchar2 (10). Why is it too long?
It wasn't until you opened it with gvim that the "status" column was actually long for elders. These empty characters are counted on the "status" header ............
Change to set line 100 pages 0 to be successful.
As a matter of fact, when the data file generated is 800 m +, I think it is not very good, but the technical level is still too good, this error is so long!
There is actually another error.
P87
Error:
Create Table objects1 (owner varchar2 (30), object_name varchar (50), object_id number, status VARCHAR2(1000),
Created date );
Should be:
CREATE TABLE objects1(owner VARCHAR2(30),object_name varchar(50),object_id NUMBER,created DATE,status VARCHAR2(1000));