Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle delete table space prompted ORA-00604 and ORA-38301     - Linux ACL permissions (Linux)

- ssh using scp: / directory: Permission denied (Server)

- Ubuntu Telnet service settings (Linux)

- Linux find command detailing (Linux)

- Learning Linux coding style (Programming)

- To install Ganglia (Linux)

- Oracle 10g relations with the constraint of column properties NULLABLE (Database)

- Perl said method B if A judge (Programming)

- Deepin Tutorial: Depth Description Installer expert mode (Linux)

- Linux remote landing system (Linux)

- How to install or upgrade to the Linux kernel in Ubuntu 4.2 (Linux)

- MySQL uses Federate engine mapping table to achieve operation of the local remote operation table (Database)

- How to Install 3.16.7 CKT2 kernel in Ubuntu 14.10, Ubuntu 14.04 and its derivative versions (Linux)

- An Example of GoldenGate Extract Process Hang Problem Solving (Database)

- Ubuntu 14.04 install Nmap 6.46.1 (Linux)

- Linux kernel IPv6 protocol closed manner (Linux)

- SVN hook code set to synchronize Web directory (Server)

- Zend Studio PHP syntax color scheme to export (Linux)

- Talk about the Linux folder permissions issue again (Linux)

- Install the open source database PostgreSQL 9.4 and phpMyAdmin on Ubuntu (Database)

 
         
  Oracle delete table space prompted ORA-00604 and ORA-38301
     
  Add Date : 2017-01-08      
         
       
         
  Today need to free up space on the machine and found that Oracle has a dbf file accounts for about 30G, the data file corresponding to a user rarely used, so wanted to deal with it - delete table space operation.

This machine is 32-bit 10.2.0.1.0 database, table space TEST_TB there are several tables of data. Just use dba role at the start of system users, direct execution

drop tablespace test_tb including contents and datafiles;

prompt:

ORA-00604: recursive SQL level 1 errors

ORA-38301: Unable to execute DDL / DML to the Recycle Bin objects

Reason: dba_segments exist in the table space test_tb data, execute queries by dba users:

select segment_name, segment_type, owner from dba_segments where tablespace_name = 'TEST_TB';

Approach:

1. The table space corresponding user login

2. Run the purge recyclebyin;

3. To re-execute the drop tablespace test_tb incluing contents and datafiles;

After the implementation, dbf file does not exist, space is vacated.
     
         
       
         
  More:      
 
- Increase ssh security service under Linux (Linux)
- MyEclipse configuration necessary (Linux)
- Articles do not resolve after opening under Ubuntu WordPress setting a fixed link (Server)
- To protect the temporary files for Linux security (Linux)
- Select helps secure the system network management tools (Linux)
- Android Dynamic efficiency articles: a brilliant Loading Analysis and Implementation (Programming)
- Basic Operation Linux files and directories (Linux)
- Installation and Configuration ISC DHCP server on Debian Linux (Server)
- MongoDB 3.2 Cluster Setup (Database)
- MySQL Tutorial: About checkpoint mechanism (Database)
- Android memory optimization of the memory cache (Linux)
- iOS in the event delivery and the responder chain (Programming)
- Enterprise-class GitHub warehousing environment build (Server)
- Linux group account deletion, and other related operations (Linux)
- How to Start a Linux application running in the background using the terminal mode (Linux)
- Redis Linux system installation guide (Database)
- ElasticSearch basic usage and cluster structures (Server)
- Linux platform NTOP Installation and Configuration (Linux)
- Cache implementation APP interacts with the server-side interface control Session (Server)
- To install Git on Ubuntu systems (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.