1. Database installation parameter settings
The version used below the database is Oracle 9i (
9.2.0
) The operation of Chinese will be more difficult to operate during operation).
2. Database user creation, the allocated database installation is complete, there are two system-level users:
1, the system default password is: Manager
2, SYS default password is: change_on_install
Locate the SQLPlus program in /racle/product/9.2/bin in the installed database directory, run: ./ Sqlplus system / manager @ ora9i
Create your own users with system users; SQL statements are as follows:
1. Create a user:
Create User UserName Identified by PWD Default TableSpace Uses Temporary TableSpace Temp;
2, user authorization
Grant Connect, Resource, DBA to Business;
3, submit
COMMIT;
3. Creating a database with database scripting Using SQLPLUS to log in with the UserName user above, enter: @ Create a script name. SQL Enter, you can create a table, view, stored procedure, etc. in the database. Note: The above creation user procedure can enable the user's table without the N multi-time table generated by the system. Creating a table space SQL: Create TableSpace "msnrobot" Logging DataFile '/opt/ora9/oradata/oracle/msnrobot.dbf' size 10m Extent Management Auto