Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle delete table space prompted ORA-00604 and ORA-38301     - Linux input and output redirection (Linux)

- Linux system performance and usage activity monitoring tools -Sysstat (Linux)

- Python Basics Tutorial - lambda keyword (Programming)

- Enterprise Hadoop cluster architecture - Hadoop installation (Server)

- Installation and use of Linux Sniffer tool Tcpdump (Linux)

- Browser caching mechanism on the analysis (Linux)

- Binary search -Java achieve (Programming)

- Linux5.8 installed phpMyAdmin was unable to issue related php-mcrypt (Database)

- init level settings for Linux / etc / inittab file into six (restart) or does not support the level of solution (Linux)

- grep command Detailed and relevant examples (Linux)

- Installation JDK 1.8 under CentOS7 (Linux)

- The basic principles for the protection of a good linux server security (Linux)

- Simple Calendar C language (Programming)

- MySQL multi-master multi-cluster deployment uses alive Galera (Database)

- Linux processes in memory and memory cgroup statistics (Linux)

- Compiling source code Nginx module installation subs_filter (Server)

- Java to create a table in the database SYBase (Database)

- TypeScript basic grammar (Programming)

- How to create a binary distribution with Bash (Linux)

- Why do you need close contact Rust 1.0 (Programming)

 
         
  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:      
 
- Find details block device with Linux blkid command (Linux)
- Ubuntu 14.04 to install Blender 2.71 (Linux)
- Win8 mount disk partitions under Ubuntu (Linux)
- Camera-based face recognition OpenCV crawl and storage format (Python) (Linux)
- Docker container plaintext password problem-solving way (Server)
- Hard disk encryption to protect data security (Linux)
- C ++ Supplements --new delete overload (Programming)
- Android Studio utility plug organize, create sharp artifact (Programming)
- 4 lvcreate example commonly used commands (Linux)
- Common Linux system performance monitoring command (Linux)
- Proficient in C / C ++ can also find a very good job (Programming)
- Terminal fun: 6 interesting Linux command-line tools (Linux)
- Ubuntu batch scp to copy files without password (Linux)
- Java in several ways of using MongoDB (Programming)
- Chkconfig set boot start under Linux (Linux)
- CentOS 7 install Hadoop-cdh-2.6 (Server)
- Use OpenSSL carried BASE64 encoding and decoding (Linux)
- Google open source TCP team repaired the Linux kernel TCP flaw (Linux)
- How to Install Redis server on CentOS 7 (Server)
- OpenWrt modify flash size (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.