Export/Import

rmascaya · Post by **rmascaya** » Sat 12 Aug 2006 06:21

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?

Duke · Post by **Duke** » Mon 14 Aug 2006 06:53

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.

rmascaya · Post by **rmascaya** » Tue 15 Aug 2006 06:08

I have the client (Oracle 10g), but when I create the connection, I can't change the Direct option. Maybe tath is the problem.

Duke · Post by **Duke** » Wed 16 Aug 2006 05:48

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.

Guest · Post by **Guest** » Wed 16 Aug 2006 06:41

Can you explain me more about system PATH variable?

Duke · Post by **Duke** » Wed 16 Aug 2006 09:17

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.