Oralce troubleshooting Summary

Oralce troubleshooting Summary 1. Unable to connect to the Oracle database during development in Visual Studio. When confirming that the connection configuration is correct, you can consider permission issues and run Studio as an administrator; 2. Dll locating occurs when you use Sqlplus or local commands for import and export. This problem is generally caused by the installation of multiple versions. The solution is simple. Modify the environment variable Path, keep the environment variable of the Oralce version; www.2cto.com
3. You cannot use imp to export a table created by Oralce: This is mainly caused by problems that may occur after the oracle 11g. By default, the new table oracle does not create table segments, although this table exists in the system, it cannot be exported through imp and impdb. The solution is to execute: alter table xxxx allocate extent; of course, inserting a piece of data can also be solved. 4. If you cannot confirm the specific issue due to Oralce permission problems, you can try to revoke the permission of the client folder and then re-grant it to solve some problems caused by permissions.