linux create user tablespace oracle
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
Related Posts of linux create user tablespace oracle
-
ORACLE10G full version centos5 installed (the installation has passed)
ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...
-
SGA extended the principle of 32bit oracle
SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...
-
AX3.0 + Oracle 10G RAC installation
During these two days, you installed RAC, in a virtual machine inside, with a full day, there have been some questions on his way. Now have their own solution. In fact, it is loaded, it is easy, as long as planned, carefully point on OK, the trouble ...
-
High Availability Oracle Flashback
Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
-
Diagnosis and principles of order
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
-
ORACLE 10G dataguard configuration Step by Step
oracle dataguard
Leave a Reply