Shulou(Shulou.com)05/31 Report--

How do I install PLSQL? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

I. preparatory work

1. The version of PLSQL installed is 12.0.7. It is recommended to install 64-bit.

2. When downloading PLSQL, there will be a "Language pack" link next to the version. Click "Chinese" on the left side to download the Chinese package.

3. Registration code

PLSQL Developer 12.0.7 Registration Code product code: 4vkjwhfeh4ufnqnmpr9brvcuyujrx3n3le serial Number:226959 password: xs374ca

4. After downloading, the figure is as follows:

2. Start installation

1. Double-click plsqldev1207x64.msi to start the installation.

2. Accept the agreement and select the version

3. If you do not want to install to the default path, click the "Change" button to customize the installation path.

4. Choose the installation method

5. Click "Install" to start the installation

6. Installation completed

7. When you open PLSQL for the first time, you will be prompted to enter license. You can directly enter the registration code in the first step.

8. To install the language pack, you need to select the installation path of PLSQL. Restart after installation.

3. Import data

The SQL statements involved can be viewed at the end of the article.

1. Create a new SQL window

2. Create a new tablespace

3. Create new users

4. Create an import and export directory and notice the "\" at the end of the directory.

5. Execute the import command in CMD, and be careful not to add a semicolon at the end of the SQL statement, otherwise it will be a bit awkward and will create a user with a semicolon that cannot be deleted. After execution, you can open the log file set by logfile in the directory set in step 4 to view the import.

6. After the import is successful, you can log in to the new user in step 3 for data operation.

7. The SQL statement that exports the data also needs to be executed in CMD.

8. Involving SQL

-- create table space-- DATAFILE: storage path of table space data file-- SIZE: initially set to 200m color-space name MOF_TEMP is not required to be the same as data file name, you can name it at will.-- AUTOEXTEND ON/OFF means to start / stop automatic extension of table space create tablespace EPS_DATA_20180929loggingdatafile 'd:\ app\ Dominic\ oradata\ orcl\ EPS_DATA_20180929.dbf'size 200mautoextend on next 100mmaxsize 20480mextent management local. -- create user-- username create user FH_20180929-- password identified by 111default tablespace EPS_DATA_20180929;-- give permission grant dba to FH_20180929;SELECT * FROM BASE_ORGANIZATION WHERE ORGANIZATION_ID = 1-- View all users-- select * from dba_users;-- impdp, expdp create directory create or replace directory expdir as'd:\ DBTemp\'; grant read,write on directory expdir to public -- Import data-- name of dumpfile data file-- name of logfile log file-- user to which the collection of schemas data objects belongs-- remap_schema need to set this item when the data comes from different sources-- remap_tablespace when the two users' tablespaces are inconsistent-- version when the database version is different. Need to set this impdp FH_20180929/111@orcl directory=expdir dumpfile=FH_20180710.DMP logfile=FH_20180710.DMP_impdp.log schemas=FENGHUO_20180710 remap_schema=FENGHUO_20180710:FH_20180929 remap_tablespace=EPS_DATA:EPS_DATA_20180929-- export data-- dumpfile data file name-- logfile log file name expdp FH_20180929/111@orcl directory=expdir dumpfile=TEST_EXPDP.dmp logfile=TEST_EXPDP.log after reading the above, do you know how to install PLSQL? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.