Oracle user tablespace

When learning about Oracle, you may encounter the Oracle user tablespace problem. Here we will introduce the solution to the Oracle user tablespace problem. Here we will share with you. In fact, it is to create a new account on an existing database instance to access some new tables.

The procedure is as follows:

1. log on to linux. Log On As an Oracle user. If the logon is performed as a root user, log on to the linux system and use the su-oracle command to switch to an oracle user)

2. Open sqlplus using sysdba. The command is as follows: sqlplus "/assysdba"

3. Check the location where Oracle user tablespace is normally placed: execute the following SQL:

 
 

  
  
select name from v$datafile; 
 
 

The preceding SQL statements usually show the location of your Oracle user tablespace file.

4. Create an Oracle user tablespace:

 
 

  
  
CREATE TABLESPACE NOTIFYDB DATAFILE 
  
  
'/oracle/oradata/test/notifydb.dbf
  
  
'SIZE 200M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 
 
 

5. Create a user and specify the password and the Oracle user tablespace created above

 
 

  
  
CREATE USER hc_notify IDENTIFIED BY hc_password DEFAULT TABLESPACE NOTIFYDB; 
 
 

6. Grant Permissions

 
 

  
  
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; 
 
 

After the above operations, we can use hc_policy/hc_password to log on to the specified instance and create our own table.

1. Detailed analysis of Oracle tablespace in seven steps
2. Let's discuss how to create an Oracle tablespace.
3. Professional Oracle tablespace reconstruction technical guidance
4. Step 6: Understand the Oracle tablespace status
5. Oracle tablespace recovery makes you no longer worry about database errors