# How can I resolve this error when import to Oracle **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [January 24, 2014, 6:15am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496 "2014-01-24T06:15:39Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [January 24, 2014, 6:15am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/1 "2014-01-24T06:15:39Z")
Hi, I have Toad Data Point 3.4 and when I try import any data to Oracle (to existing table or to new created table), I always get this error: 14:55 Thread (24) Tried to access non existing SQL name (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase) 14:55 Thread (24) Error importing data, please check file format options: Tried to access non existing SQL name (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase) 14:55 Thread (24) Import Finished [24.1.2014 14:55] 14:55 Thread (24) Import time: 00:00:05.0245024 I have TDP for half year, always importing same file in same format without any errors. Is this problem caused by file or connection configuration? Any ideas how to resolve it? I’m importing .csv file. Thanks a lot! Martin ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [January 24, 2014, 5:34pm UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/2 "2014-01-24T17:34:57Z")
The error stack is complaining about the schema name. See image. Is the schema name valid? If it is can you Save the import template to a file and post? ![schemaOption.png](https://global.discourse-cdn.com/quest/original/2X/6/655054178b8b1e28401f86cb2a79b7464767e665.png) ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [January 27, 2014, 12:03am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/3 "2014-01-27T00:03:58Z")
Schema name is valid. See import template in attachment. It is my own schema, where I'm currently logged. In previous installation of TDP, all seems to be OK, import was fast and without problem. After my system re install in January this happens. In old Toad for Oracle 9 import was finished without problem, but is much much slower then import in TDP. Here are some screens of my TDP screen, so you can see how I'm logged in. ![0317.Schema.png](https://global.discourse-cdn.com/quest/original/2X/a/ab6a4e3fa1765d043e4cb7f675c95fb502b7fef8.png) end actual error ![5428.Err.png](https://global.discourse-cdn.com/quest/original/2X/f/f86380e77c132374d064f2249820e8710b319aad.png) Thanks for help. Martin [IMPORT\_TST.zip](https://forums.toadworld.com/uploads/default/original/2X/8/8e86435a0599875ea482b06667f43c28c18805fb.zip) (690 Bytes) ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [January 28, 2014, 4:38pm UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/4 "2014-01-28T16:38:32Z")
What version of Oracle are you connecting to? It appears that your SQL Dictionary gpt messed up. Please save the attached SqlDictionary.xml to your Toad Application Data Directory ( you can find the path by clicking Application Data Directory link in About box), restart Toad and try the import again. Hope this helps. [SqlDictionary.xml](https://global.discourse-cdn.com/quest/original/2X/3/3c9a37a553bc3a8e22c709043f3666d032677e8c.xml) (191 Bytes) ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [January 29, 2014, 1:02am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/5 "2014-01-29T01:02:30Z")
Thanks for your reply, but error is still the same. I copied your xml file to Data folder. Now it looks like this ![toad_data_dir.png](https://global.discourse-cdn.com/quest/original/2X/7/7a3a72308bca3063dc121d55c692fb7b5f82c42c.png) Here is our Oracle component version info: PRODUCT VERSION STATUS NLSRTL 10.2.0.4.0 Production Oracle Database 10g Enterprise Edition 10.2.0.4.0 64bi PL/SQL 10.2.0.4.0 Production TNS for Solaris: 10.2.0.4.0 Production What is really strange is a fact, that before TDP reinstall all works like a charm...it must be caused by some change in last update of TDP. Thanks for all ideas. ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [February 2, 2014, 12:35pm UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/6 "2014-02-02T12:35:58Z")
No other ideas? Is there any possibility to log all commands which Toad sending to Oracle server? Thanks. Mertin ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [February 3, 2014, 2:38pm UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/7 "2014-02-03T14:38:59Z")
Mertin, I’m working on adding some log to the oracle commands in import wizard. In the mean time, would you like to reinstall your Toad to see if it helps? Thanks! ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [February 4, 2014, 1:38am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/8 "2014-02-04T01:38:10Z")
Yes, I reinstall it several times. Even with some special uninstall tool for deleting all temp files and register entries. I testeted old version (3.3) and beta version (3.5) too. Logging will be great, this can be some problem in our Oracle configuration, but now i can’t identify it. My company considering the purchase about 30 licenses. I have it for testing (i have only trial version now) . But if we can’t resolve this issue, it will be big problem for us. Importing large files is with us on a daily basis and TDP can be user-friendly alternative for all our platforms (Oracle, Teradata, MySQL). And I’m Martin, it was typing error 🙂 ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [February 5, 2014, 10:46am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/9 "2014-02-05T10:46:31Z")
Martin, I added more log to catch possible exceptions . Please try the following steps: 1. Download the beta build and install it. [community-downloads.quest.com/…/ToadDataPointBeta\_3.5.0.2599.zip](http://community-downloads.quest.com/toadsoft/tda/ToadDataPointBeta_3.5.0.2599.zip) 1. Launch the beta and migrate settings from version 3.4 3.Click the link application data directory in about box, it opens up the the setting folder, please delete ExceptionTrace.log 1. Connect to your Oracle server and reproduce the import issue you had 2. Please send me the following items to debug your issue - Screenshot and content of the import log - ExceptionTrace.log - Support bundle zip file ( Help -\> support bundle) Let me know if you need any clarification. Thanks, Kiki ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [February 7, 2014, 9:37am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/10 "2014-02-07T09:37:16Z")
Hi, sorry for my delay. Here is it. If you need something else, let me know. Thanks for your help! Martin [ERR\_LOG.zip](https://global.discourse-cdn.com/quest/original/2X/e/e92c8a45b6a6f4a34944b90d99d4080ef9e28716.zip) (67.2 KB) ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [February 7, 2014, 5:03pm UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/11 "2014-02-07T17:03:57Z")
This is really werid. Could you execute this command? ALTER SESSION SET CURRENT\_SCHEMA = “MARTVES1” ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [February 8, 2014, 3:33am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/12 "2014-02-08T03:33:32Z")
Yes, without problem. See screenshot ![alter_session.png](https://global.discourse-cdn.com/quest/original/2X/3/3bb63a1c31014a097d326600def035a67e6e0587.png) Martin ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [February 12, 2014, 9:22am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/13 "2014-02-12T09:22:55Z")
Martin, Thank you for your patience. I added more debug code. Please download the new beta, do the same steps ,and send new log files to us for investigation. [community-downloads.quest.com/…/ToadDataPointBeta\_3.5.0.2624.zip](http://community-downloads.quest.com/toadsoft/tda/ToadDataPointBeta_3.5.0.2624.zip) Since the issue is quite perplexing, we also want to know if you are open to have a webex with us if the new log files do not reveal the information we are expecting. Thanks, Kiki ---
**Author:** ![m-ves](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@m-ves](https://forums.toadworld.com/u/m-ves)\ **Post date:** [February 20, 2014, 5:08am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/14 "2014-02-20T05:08:47Z")
Hi Kiki, sorry for my delay…vacation… 🙂 So, error look still same. All what you want is in attached .zip . Webex is no problem, but we must agree time because I’m in Prague (UTC+1) Martin [TDP\_IMPORT\_ERR.zip](https://global.discourse-cdn.com/quest/original/2X/6/63a8518e21ee7ff2f31ff9e0c4816014a445ef98.zip) (172 KB) ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [February 24, 2014, 10:03am UTC](https://forums.toadworld.com/t/how-can-i-resolve-this-error-when-import-to-oracle/28496/15 "2014-02-24T10:03:18Z")
Martin, I think your 5 - 6:00 pm ( our 8 - 9:00 am) will be a good time slot. Please email me directly at [yake.li@quest.com](mailto:yake.li@quest.com) to discuss the details. Thanks!