0

I am looking to copy a table with employee information from my company's test database, to the production database in Advanced Query Tool. The first thing i did was to export the table data in a csv file, then trying to import the same data into the test database, but i get an error saying: "Unable to create table" error during ExecDirect 37000(972)[Oracle][ODBC][Ora]ORA-00972: Identificator is too long"

  • What is this "Advanced Query Tool"? –  May 08 '18 at 10:05
  • http://querytool.com/ –  May 08 '18 at 10:06
  • Are both of your databases Oracle? Open up your CSV file and check the header row (assuming there is one) and verify that there are no identifier names longer than 30 characters. – Bob Jarvis - Слава Україні May 08 '18 at 10:27
  • Both are Oracle yes, and if one of the databases is longer than 30 characters what do you suggest i do? –  May 08 '18 at 10:53
  • Is'n it easier to do the same with create table as select...? No tools needed. – Art May 08 '18 at 12:58
  • Well how do i create table in another database connection? When i log in to the test database the table i need to copy to production database is there, but when i log in to the production database there is no table. –  May 09 '18 at 06:35

0 Answers0