Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle delete table space prompted ORA-00604 and ORA-38301     - Four safety delete files under Linux tools (Linux)

- High-performance JavaScript reflows and repaints (Programming)

- Nginx start, stop, smooth start, smooth upgrade (Server)

- Getting the Linux shell expr use (Programming)

- Oracle Database routine inspection (Database)

- Linux install Samba file sharing server (Server)

- DM9000 timing settings (Programming)

- Android graphic introduction NDK installation and simple jni demo implementation (Linux)

- Linux rpm command Detailed (Linux)

- Ubuntu 14.04 Enable root and disable the guest (Linux)

- CentOS6.5 install SVN & visual management tools iF.SVNAdmin (Server)

- a virtual machine created migrated to host RHEL6.4 on Ubuntu 14.04 (Linux)

- Introduction to Linux system process monitoring tools (Linux)

- Ubuntu Telnet service settings (Linux)

- Udev: Device Manager for Linux Fundamentals (Linux)

- Linux / BSD firewall M0n0wall Profile (Linux)

- IntelliJ IDEA common list of shortcuts (Linux)

- On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL (Server)

- After Oracle 11g dataguard failover rebuild the archive logs are not applied to be NO problem (Database)

- To install Ganglia (Linux)

 
         
  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:      
 
- Oracle 11G using DG Broker create DataGuard (Database)
- Scope of variables in Object-C (Programming)
- LaTeX Getting Started Tutorial (Linux)
- Java framework for parallel study - ForkJoin (Programming)
- linux remote control software (Linux)
- Install the system cleaning software under Linux: BleachBit 1.4 (Linux)
- CentOS6.6 ordinary users to use sudo command to borrow root user privileges (Linux)
- Shell Script: create a function and specify a directory for download (Programming)
- Linux memory management (Linux)
- grep regular expression (Linux)
- Oriented C ++ test-driven development (Programming)
- Linux system monitoring, top command of the diagnostic tool Detailed (Linux)
- Compile Android libwebcore.so error occurs when solving (Programming)
- Linux /var/spool/ insufficient clientmqueue space solutions (Linux)
- Linux open handle limit adjustment (Linux)
- Android Fragment everything you need to know (Programming)
- Java Cookie Comments (Programming)
- How to create a cloud encrypted file system in Linux systems (Linux)
- Through the source code to install MySQL 5.6.26 under CentOS6 (Database)
- Use small network command to check whether PC Security (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.