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

- Oracle archive log size than the size of the online journal of the much smaller (Database)

- How screenshots from the Linux command line (Linux)

- Linux garbled file delete method (Linux)

- Why did not Oracle privileges can also log in with sysdba (Database)

- A drop datafile Oracle bug (Database)

- OpenNMS compile under Linux (Server)

- Keepalived achieve high availability Nginx Reverse Proxy (Server)

- The most commonly used Linux commands (Linux)

- WEB-based Android Remote Tools Python implementation (Programming)

- Ubuntu 14.04 next upgrade to GNOME 3.12 (Linux)

- Linux Command Tutorial: Ubuntu apt-get command (Linux)

- CentOS 7 repair MBR and GRUB (Linux)

- The Linux C truncate function clears the file notes (Programming)

- CentOS6.5 installation Docker (Linux)

- High-performance open-source http accelerator Varnish introduce (Server)

- Java implementation chain store binary search tree (recursive method) (Programming)

- Linux 6 use UDEV binding shared storage (Linux)

- Protobuf compiled and used on the Ubuntu 14.04 (Programming)

- blecat: Bluetooth Gadgets (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:      
 
- Linux, Oracle listen address modification (Database)
- Use Visual Studio to compile and use WinGDB remote debugging embedded Linux programs (Programming)
- Atlassian Linux Shell Scripting the confluence remote backup methods (Linux)
- Ubuntu is not in the sudoers file problem solving (Linux)
- How to use GRUB2 files directly from the hard disk to run ISO (Linux)
- SQL statement to repair SQL Server database (Database)
- Python Basics Tutorial - lambda keyword (Programming)
- Linux and Unix systems really do network more secure (Linux)
- CentOS 6.5 makes the LAN http source (Linux)
- HBase table data processing tab (Database)
- LVM management parameters commonly used commands explained in detail (Linux)
- Android Launcher3 Application List Modify a transparent background (Linux)
- RHEL5 establish a local yum source (Linux)
- How do I use Linux development environment (Linux)
- CentOS 7.0 local address and configure yum source address priority (Linux)
- How to create a new file system / partitions under Linux terminal (Linux)
- Ubuntu 14.10 used ifconfig commands to manage your network configuration (Linux)
- Kubuntu 14.04 desktop to the user how to upgrade KDE 4.13.2 (Linux)
- Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions (Database)
- True and false in Perl (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.