import text file
- Thread starter matas
- Start date
If you want to load it into a CLOB or LONG column, you can simply use the 'Edit Data' function for a table, and paste the text into the text editor of the column.
If you want to load it line by line into a record per line, then there is no specific support. You could use a macro to convert the lines into the necessary insert statements.
------------------
Marco Kalter
Allround Automations
If you want to load it line by line into a record per line, then there is no specific support. You could use a macro to convert the lines into the necessary insert statements.
------------------
Marco Kalter
Allround Automations
Don't know about text files, but here is how I sometimes insert from an excel spreadsheet into an "edit table data" window...
- obviously make sure the column position/mapping from the excel worksheet matches the table format that you will be inserting into.
- open an "edit data" window in Developer for the particular table.
- in the spreadsheet, insert a blank column at the front of the spreadsheet.
- highlight and copy your spreadsheet rows that you want to import into Oracle (including the blank column at the front of the worksheet).
- highlight the empty row in the "edit data" window by clicking on the row selector at the far left.
- ctrl-v or right click and choose 'paste'.
- post your rows
- commit your transaction.
Kindof goofy but it is nice to use at times. using sqlldr would obviously be much faster if you didn't mind creating a control file for the mapping. But for relatively small bunches of data, this works pretty well.
[This message has been edited by Bullitt (edited 06 February 2003).]
- obviously make sure the column position/mapping from the excel worksheet matches the table format that you will be inserting into.
- open an "edit data" window in Developer for the particular table.
- in the spreadsheet, insert a blank column at the front of the spreadsheet.
- highlight and copy your spreadsheet rows that you want to import into Oracle (including the blank column at the front of the worksheet).
- highlight the empty row in the "edit data" window by clicking on the row selector at the far left.
- ctrl-v or right click and choose 'paste'.
- post your rows
- commit your transaction.
Kindof goofy but it is nice to use at times. using sqlldr would obviously be much faster if you didn't mind creating a control file for the mapping. But for relatively small bunches of data, this works pretty well.
[This message has been edited by Bullitt (edited 06 February 2003).]
Stew Stryker
Member³
Is there still no support for importing a CLOB using the Text Importer tool? A coworker is trying to import a file he'll get regularly from a vendor. Two of the records have a column longer than 2k.
He's getting the error: "string literal too long"
Hoping...
This is indeed a known restriction. It is on the list of enhancement requests though.
Stew Stryker
Member³
Marco,
Oh well.
I guess we'll have to use SQL*Loader instead.
Thanks.
Oh well.
I guess we'll have to use SQL*Loader instead.
Thanks.
Malte Schnack
Member
What about enhancing the TextImporter to offer alternative Support for SQL*Loader controlfile generation? Could be a further point for the todo list.
Similar threads
