Shulou(Shulou.com)05/31 Report--

Editor to share with you what the daily operation of exp, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Track the exp export operation

Strace-o sexp.txt exp user/password file=exptable.dmp buffer=4096000

Or

Ps-ef | grep exp

Strace-c-p exp_pid

Eg:

[oracle@orcl] $strace-c-p 3859

Process 3859 attached-interrupt to quit

Process 3859 detached

% time seconds usecs/call calls errors syscall

--

87.38 0.004672 2336 2 brk

6.62 0.000354 0 2045 write

6.00 0.000321 0 1882 read

0.00 0.000000 0 5 close

0.00 0.000000 0 18 lseek

0.00 0.000000 0 4 munmap

0.00 0.000000 0 1 rt_sigaction

0.00 0.000000 0 2 rt_sigprocmask

--

100.00 0.005347 3959 total

2 、 EXP-00091: Exporting questionable statistics

[oracle@orcl ~] $exp lineqi/lineqi file=/home/oracle/aaa.dmp tables=aaa query=\ "where id=2\"

Export: Release 11.2.0.4.0-Production on Sat Oct 21 13:22:12 2017

...

About to export specified tables via Conventional Path...

. . Exporting table AAA 1 rows exported

EXP-00091: Exporting questionable statistics

Export some of the data in the table to indicate that there is a problem with the statistical information. You can add the statistics=none parameter here.

Exp lineqi/lineqi file=/home/oracle/aaa.dmp tables=aaa query=\ "where id=2\" statistics=none

About to export specified tables via Conventional Path...

. . Exporting table AAA 1 rows exported

Export terminated successfully without warnings.

When EXP-00091 appears, it is also possible that the database character set is inconsistent with the customer character set (NLS_LANG).

Select * from v$nls_parameters where parameter like 'NLS_CHARACTERSET%'

NLS_CHARACTERSET AL32UTF8

[oracle@orcl ~] $echo $NLS_LANG

AMERICAN_AMERICA.ZHS16GBK

[oracle@orcl ~] $exp lineqi/lineqi@satdb file=/home/oracle/aaa04.dmp tables=aaa

Export: Release 11.2.0.4.0-Production on Sat Oct 21 13:36:18 2017

About to export specified tables via Conventional Path...

. . Exporting table AAA 14 rows exported

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

3. Get the table information in the exp exported dump file

Strings test02.dmp | grep "CREATE TABLE" | awk'{print $3}'| sed's / "/ / g'

AAA

BFW_TEST

CBC_TEST

EMP1

PAGE

Strings test02.dmp | grep "CREATE TABLE" | awk'{print $3}'| sed's / "/ / g' | awk'{if (FNR==1) print" table= "$1X else print", "$1}"

Table=AAA

, BFW_TEST

, CBC_TEST

, EMP1

, PAGE

The above is all the contents of the article "what are the daily operations of exp?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.