The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the PL/
database. Wait a moment and prompt that the export is complete. Then run the following command to import data:
>oracle_ctl[oracleusername][password]
You do not need to specify the database name or the like here, because it has already been specified in the script.
Wait for a moment after the import is complete.
At this point, the knowledge about migrating SQL to Oracle by SQL
The following tips only apply to PL/SQL developer 6 and later versions. Version 5 only has some features.1. Right-click the menuRight-click an object name in each text editing window in PL/SQL developer (PLD), such as SQL window, command window, And porgram window, A menu co
Tutorial on using the SQL search 1.1.6.1 edition SQL query and analysis tool in red gate Series
Red Gate SeriesArticle:
SQL compare 10.2.0.1337 edition, one of the red gate series, database comparison tool, complete cracking + tutorial
Red Gate Series ii
MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program. The official website is: Http://www.navicat.com.cn/products/navicat-premium. Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. 3, Pl\sql Developer 10.0.5.1710 PL/
,
Billy YaoMicrosoft online partner support----------------------------------------------------Get secure! -Www.microsoft.com/securityThis posting is provided "as is" with no warranties and confers no rights.Please reply to newsgroups only. Thanks.
Artek10-24-03, 05: 26 Hello, Billy,
Thank you for your reply
With regards to my problem, yes you unerstood well.
This means that distributed query from sql64 does't work with sql32 (in
Oposite direction it works ).
I checked Distributed Que
Recently, because of the job needs, the boss asked the Oracle database on the server to migrate data to another server, I am not very familiar with Oracle, the migration of the database This is a matter of time spent, but also on the internet to inquire a lot of information. All kinds of moves are exhausted or not successfully migrated.Finally, the spirit of the dead horse as a live horse doctor, the Oracle
feature, because remembering passwords can give data security problems.But if it is the development of the library, the password can even be the same as the user name, each input password is really meaningless, you can consider let Plsql developer remember the password.Location: Tools menu--preferences--oracle--logon history--store with password3, double-click to display table dataPlsql developer The defau
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
Tags: style blog http using OS data IO 2014OracleWhy Choose Oracle1.oracle is capable of running on a mainstream platform, and Windows is only supported on SQL Server, and it's in WR, so you know. In many places, Oracle and Linux are a good choice in terms of security.2. Supported connection modes, Oracle can support the OLEDB,JDBC,OCI and other standards to connect.3. From the 80 onwards, Oracle began the
PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client. 2. Install Oracle ClinetOracle client must be 32-bit only, the installation process is omitted .... After installation, create the Network/admin in the client's home directory, and then new the Tnsnames.ora file under the ADMIN subdirector
ArticleDirectory
Download SQL 2000 Simplified Chinese Enterprise Edition
Microsoft SQL Server 2000 Service Pack 4
Download SQL 2000 Simplified Chinese Enterprise Edition
Recently I found this
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
SQL sever2000 Green Edition, saying goodbye to the troubles of installing SQL during Software Distribution
Have you ever encountered such a situation, software developers, that is, the software we have worked hard to develop, and the database is based on SQL Sever? When we distribute it, we will find that, what if our
Label:installed a Oracle 12c is not able to connect to Oracle 12c after using PL/SQL developer. Look online, according to Fcflying said the operation succeeded, so make a note: 1) Install Oracle 12c 64-bit : HTTP://WWW.ORACLE.COM/TECHNETWORK/CN/DATABASE/ENTERPRISE-EDITION/DOWNLOADS/INDEX.HTML?SSSOURCESITEID=OCOMCN 2) Installing the 32-bit Oracle Client (instantcl
Tags: des style blog tar width get1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL developer, and note that when you install the PL/SQL developer software, do not install in the program Files (x86) directory, or PL/
Label:After installing Oracle (64-bit), PL/SQL developer, execute PL/SQL occurs for example the following error:On the Internet, my PL/SQL developer is incompatible with Oracle, that is, PL/SQL does not support 64-bit Oracle, so t
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.