I was importing data into HANA Dynamic Tiering and encountered below error.
* 2: general error: Table does not exist SQLSTATE: HY000
You will see this error if TABLE NAME is wrong. I have verified that table exists in the database but still see same issue and I have verified the syntax of the control file and everything looks good.
IMPORT DATA INTO TABLE "dtuser"."employee" FROM '/hana/shared/DT/HDB00/work/employee.txt'
RECORD DELIMITED BY '\n'
FIELD DELIMITED BY '|'
OPTIONALLY ENCLOSED BY '"'
ERROR LOG '/hana/shared/DT/HDB00/work/employee.log'
I see that user and table name is in lower case. I have modified the control file to use upper case for user/ table name and I was able to IMPORT successfully.
Other possible errors you may encounter:
- 2: general error: Cannot open the file, /hana/shared/DT/HDB00/work/employee.txt SQLSTATE: HY000
- 2: general error: Cannot open Control file, /hana/shared/DT/HDB00/work/employee.ctl
Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
Contact us if your are looking for wp plugin for your website.....
ReplyDeleteشركة نقل عفش بالقصيم
ReplyDeleteشركة نقل عفش بخميس مشيط
شركة نقل عفش بابها
I appreciate your efforts in writing such a wonderful post...Thanks for sharing...Please check my links for
ReplyDeleteCall girl services in Guwahati
Call girl services in Guwahati
Call girl services in Guwahati
Call girl services in Guwahati
افضل شركات منطقة مكة المكرمة ومنطقة المدينة المنورة التي تعمل في مجال نقل العفش مع الفك والتركيب والنقل والتغليف تلك الشركات التي تستخدم سيارات مجهزة ومبطنة من الداخل لكي يتم نقل العفش في امان تام بدون خدوش او تكسير مثل الشركات التالية
ReplyDeleteنقل عفش بجده
شركه نقل عفش بمكه
شركه نقل عفش بالطائف
وفي منطقة المدينة المنورة تجدنا نمتلك افضل شركات نقل الاثاث مع الفك والتركيب وكذلك في ينبع وينبع البحر مثال عن تلك الشركات
شركه نقل عفش بالمدينه المنوره
شركه نقل اثاث بينبع
MP Board Class 11th Previous Year Syllabus 2023, and Exam Pattern are Given Below. Students can Download Syllabus 2023 Once They Upload on Their Official Website. Subjects of MP 11th Class are General Language, MP 11th Lessons 2023 Special Language, and Others. MP Board Class 11th Previous Year Syllabus 2023, and Exam Pattern are Given Below. Students can Download Syllabus 2023 Once They Upload on Their Official Website. Subjects of MP 11th Class are General Language, Special Language, and Others.
ReplyDelete