Deployment Environment Description:
OperationWork
SystemUnified: Window 7
OracleManage applications: Pl SQL
1. Select the Oracle version that supports Windows 7 and download it.
Currently, the oracle version that fully supports Windows 7 is 11.2 GB.
Additional instructions: Oracle 10g version released on December 1, 2003
Oracle 11g was released on August 1, 2007.
These two versions are available in win7The self-check fails during operating system installation. After compatibility, the installation can be completed. After the installation is complete, some services cannot be started..
The download address for Oracle 11.2g is as follows:
Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html? SsSourceSiteId = ocomcn
Note: It is free to register an Oracle account and install Oracle for commercial purposes.
2. Select the 32-bit and 64-bit installation files based on the number of digits of the operating system,
Win32_11gR2_database_1of2.zip
Win32_11gr2_databasesilicate f2.zip
After the download is complete, extract the two compressed files to a folder and install them in sequence.
3. Use pl SQL to create a user and grant the view creation permission.
- Use the Administrator account to enter plsql
And select the User object set on the left.
- Right-click to create a new user
- Set tablespace and temporary for users
Tablespace
- Configure user accounts, passwords, and grant connect and resource Permissions
Set the user's permission to create a view
Grant create any view to [user name]
4. Import script
Log in with the newly created account and open
Command dialog box
Run
@ D: \ test. SQL script