linux create user tablespace oracle

Posted on 2009-06-23 filed under: Oracle (RSS) 21 views

In the existing database instance to create a new account, visit some of the new table
rn
Steps are as follows:
rn
1, log on linux, in order to oracle user login (if the root user is logged on, log in using su - oracle command to switch into oracle user)
rn
2, in order to open the sysdba way sqlplus, the following command: sqlplus "/ as sysdba"
rn
3, check out our routine will be the location of the user table space: the implementation of the following sql:
rn
select name from v $ datafile;
rn
Above the general will of the sql user table space you check out the location of the file.
rn
4, create a user table space:
rn
CREATE TABLESPACE NOTIFYDB DATAFILE '/ oracle / oradata / test / notifydb.dbf' SIZE 200M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
rn
5, the creation of users, specify a password and a user created table top space
rn
CREATE USER hc_notify IDENTIFIED BY hc_password DEFAULT TABLESPACE NOTIFYDB;
rn
6, to give permission
rn
grant connect, resource to hc_notify;
grant unlimited tablespace to hc_notify;
grant create database link to hc_notify;
grant select any sequence, create materialized view to hc_notify;
rn
After the above operation, we can use hc_notify / hc_password examples designated registry, create our own form of