Page 1 of 1

Export/Import

Posted: Sat 12 Aug 2006 06:21
by rmascaya
When I try to export, I have the follow error:

"Export and Import features are not avalible for direct mode conecctions."

How I can resolve that?

Posted: Mon 14 Aug 2006 06:53
by Duke
Export and Import features use standard Oracle utilities Exp and Imp, which are part of the client software. So you need client for these operations.

Posted: Tue 15 Aug 2006 06:08
by rmascaya
I have the client (Oracle 10g), but when I create the connection, I can't change the Direct option. Maybe tath is the problem.

Posted: Wed 16 Aug 2006 05:48
by Duke
Make sure that Oracle client's bin directory is includes to your system PATH variable and verify that PATH is not too long. Most likely that program cannot see Oracle Home directory.

Posted: Wed 16 Aug 2006 06:41
by Guest
Can you explain me more about system PATH variable?

Posted: Wed 16 Aug 2006 09:17
by Duke
1. Open System Properties dialog
2. Go to Advanced Tab
3. Click Environment Variables button
4. In Environment Variables dialog select System Variables list
5. Place path to Oracle client bin directory at the beginning of the PATH string
6. Save changes and restart your computer

By the way, if you were the one who asked about the avatar then you need to register on forum and you'll be able to upload avatar from your Profile page.