Oracle mobile data file Method

The following two methods are applicable to the online and offline statuses of Oracle mobile data files in unix or linux environments. If you are interested, take a look.

Oracle mobile data file:

Online status of the alter tablespace method ):
This method requires that the data file neither belong to the SYSTEM tablespace nor to the tablespace containing the ACTIVE rollback segment or temporary segment.

 
 

  
  
$ sqlplus '/as sysdba' 
 
 

# Offline the tablespace corresponding to the data file to be moved

 
 

  
  
SQL> alter tablespace ipas_acct_data offline 
 
 

# Cp the data file to the directory you want to put.

 
 

  
  
SQL> !mv /opt/oracle/wacosdata/ipas_acct_data001.dbf /opt/oracle/nms/oradata/ipas_acct_data001.dbf 
 
 

# Modify the location of database files in a tablespace.

 
 

  
  
SQL> alter tablespace ipas_acct_data rename datafile '/opt/oracle/wacosdata/ipas_acct_data001.dbf' to '/opt/oracle/nms/oradata/ipas_acct_data001.dbf' 
 
 

# Online the tablespace.

 
 

  
  
SQL> alter tablespace ipas_acct_data online 
 
 

# View the Modification result.

 
 

  
  
SQL> select file_name from dba_data_files where tablespace_name = 'IPAS_ACCT_DATA'; 
 
 

Alter database method offline ):
This method can be used to move data files in any tablespace.

 
 

  
  
$ sqlplus '/as sysdba'  
  
  
SQL> shutdown immediate  
  
  
SQL> !mv /opt/oracle/oradata/wacos002.dbf /ora10g/oradata/wacos002.dbf  
  
  
SQL> startup mount  
  
  
SQL> alter database rename file '/opt/oracle/oradata/wacos002.dbf' to '/ora10g/oradata/wacos002.dbf';  
  
  
SQL> alter database open;  
  
  
SQL> set head off  
  
  
SQL> SELECT file_name from dba_data_files where tablespace_name = 'WACOS'; 
 
 

Oracle Log File Reconstruction Method

Concepts of oracle users

Add Oracle user information in Linux

Measure the test taker's knowledge about the ORACLE user authentication mechanism.

Oracle tablespace statements