Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"Invalid Line" error when using ttImportFromOracle -tableFile command

mac2Jun 18 2014 — edited Jun 19 2014

Ran the command and got an error as indicated below:

c:\oracle>ttImportFromOracle -oraConn myUser/myPassword@myDB -tableFile C:\oracle\table_list.txt

Error: Invalid Line 'mySchema.myTable2' in file 'C:\oracle\table_list.txt'

Use '-help' for more information

table_list.txt looks like below, except I have 112 total tables in the list, one table per line as directed in the help documentation.

mySchema.myTable

mySchema.myTable1

mySchema.myTable2

I have tried making the table_list.txt file have only the table names (without the schema) and the same error happens.

The invalid line is always the last table in the file. So if I remove the table it complains about, it just always complains about whichever table is last in the file.

Can anyone tell me what I am doing wrong?

Thanks,

Matt

This post has been answered by mac2 on Jun 18 2014
Jump to Answer

Comments

mac2
Answer

To work around the error, I just used -tables instead.

Marked as Answer by mac2 · Sep 27 2020
ChrisJenkins-Oracle

Hi,

This specific error message is output only in the case that an input line from the file does not contain a newline (linefeed) character within the first 96 characters. So maybe your input file is not in the right format... Perhaps it only has carriage return line endings?

What platform are you running on and how was the input file created?

Chris

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2014
Added on Jun 18 2014
2 comments
1,409 views