An Oracle smear Error

Source: Internet
Author: User

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));

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.