Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle 11g Export guide problem not an empty table     - Java uses JDBC connect database (Programming)

- Linux system started to learn: the Linux syslog (Linux)

- Nodejs mysql pool Example (Programming)

- MongoDB simple replication configuration (Database)

- Normal start Lazarus 1.0.8 under Ubuntu (Linux)

- MySQL query optimization: profile function (Database)

- A summary of Java multi-threaded programming - acquaintance multithreading (Programming)

- Laravel cache paged results (Server)

- Swift used in the application to add a local push at the specified time (Programming)

- Git uses Details (Linux)

- To achieve a two-way static NAT stateless available modules on Linux (Linux)

- Talk Packages (Linux)

- Start Linux ISO image directly from the hard disk (Linux)

- CentOS yum configuration under local sources (Linux)

- Git / Github use notes (Linux)

- Postmodern systems programming language (Programming)

- C ++ stderr / stdout redirected to a file (Programming)

- CentOS6 5 Configure SSH password Free (Linux)

- Web cache basics: terminology, HTTP headers, and caching policies (Server)

- Ubuntu 15.10 under Python + Apache + CGI fully configured (Server)

  Oracle 11g Export guide problem not an empty table
  Add Date : 2018-11-21      
  Oracle 11g will encounter such a problem, the whole library derived by exp, will encounter such a problem, the library can not export an empty table

select * from all_all_tables aa where aa.owner = 'User name uppercase' --- View all user table

select * from all_tables t where t.owner = 'User name capitalized' and t.num_rows = 0; - see all users at an empty table

Well, here is the processing method script:

In the command window, run:

set heading off;
set echo off;
set feedback off;
set termout on;
spool D: \ allocate.sql;
Select 'alter table' || table_name || 'allocate extent;' from user_tables where num_rows = 0;
spool off;

After the run is complete, and then in the command window to allocate.sql executed once, then you can use exp statement, so an empty table can be turned out
- The first deployment of cross-platform operation Rafy record (Server)
- MySQL development common query summary (Database)
- Linux unpack the tar file to a different directory (Linux)
- Lenovo Ultrabooks Ubuntu system can not open the wireless hardware switch solutions (Linux)
- Linux Getting Started tutorial: XWindow what (Linux)
- VNC configuration detailed analysis under Linux (Linux)
- Spring AOP (Programming)
- Ubuntu Tutorial - Manually install Oracle Java JDK 8 (Linux)
- Python3 multi-thread download codes (Programming)
- Shared directory settings between Linux and Linux (Linux)
- Oracle RMAN-06023 and ORA-19693 errors (Database)
- Manager Docker browser (Server)
- Compression software on a simple comparison of zip and gz (Linux)
- JEdit 5.2 Pro Edition installation on Ubuntu 14.04 (Linux)
- Execute command sentence can result in equipment permanently bricked in Linux laptop (Linux)
- ctop: monitor container performance Linux command line artifact (Linux)
- Archive log file size and redo log file size relationship (Database)
- Ubuntu upgrade to Linux Kernel 4.2.3 Kernel (Linux)
- Sqoop data export import command (Database)
- Understanding Java classes (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.