CODEWITHSUNDEEP
oracle-databaseimportoracle11gcharacterutf
rvpals
rvpals

Reputation: 189

Oracle Import option

I have a simple question, how exactly do you use the oracle import tool to import a database with the option of automatically resize the column length, so it automatically fits the data before importing the data.

Give you an example: if I have a table TABLE1 that has a column called "comment", comment field length is 250. Since I'm importing TABLE1 from source (which is in western character set) into target database (which is AL-UTF32 character set). Some of the records data will grow, i.e. 1 record's comment field data will grow from 250 into 260 because of the character set conversion.

My question is: how do I import TABLE1, so that target database will automatically change the field "comment" from 250 into the max data field length of this field (after character set conversion grows the data). So I can import TABLE1 with no errors.

What's the import option or command line? Is there a way to know which columns cause data issue?

Thank you

Upvotes: 0

Views: 128

Answers (1)

Politank-Z
Politank-Z

Reputation: 3721

Ideally, you would build your target table beforehand, with the column widths you need defined at that point. You would then tailor a sqlldr (SQL Loader) control file to your input format.

Upvotes: 1

Related Questions