Home » RDBMS Server » Server Utilities » EXP error (Oracle 10.2.0.4 , Linux AS4)
EXP error [message #391824] Fri, 13 March 2009 14:33 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

When I'm trying to do an schema export like this

exp system/*** file=/opt/export/ctrgmar13.dmp log=/opt/oracle/ctrgmar13.log owner=ctrg direct=y

I'm getting the below warnings

EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table WCM_USER_PREF_R 104 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table WCM_USER_PREF_S 52 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table WEBC_LOCK_S 77 rows exported


Is there anything wrong with the syntax? What can be done to solve this .

Please help me .

Regards,
Raj
Re: EXP error [message #391825 is a reply to message #391824] Fri, 13 March 2009 14:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Always search before posting.
Just look two posts below yours. It was asked and answered hardly a few hours ago.

And,
please use CODE tags. After all these postings, you are supposed to know this.

[Updated on: Fri, 13 March 2009 14:42]

Report message to a moderator

Re: EXP error [message #391826 is a reply to message #391825] Fri, 13 March 2009 14:43 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hi Mahesh,

I solved it . I re - exported and gave as statistics=none and this time it worked .

And one more small thing . After importing into the dev box , we analyze the tables by giving
SQL> analayze table emp compute statistics ;

for this we also have a PL/SQL procedure , right ?

I'm not sure if it's

SQL> exec dbms_utility.analyze_schema('SCOTT','COMPUTE');

Is the above syntax right .

Please helpe me out . I need to use that . May be I'll learn from this.

Re: EXP error [message #391828 is a reply to message #391826] Fri, 13 March 2009 14:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is the above syntax right .
Seems you are always interested in the syntax.
Make no sense to me.
If it is wrong, trust me, Oracle will let you know.Wink

Is the above syntax right?
Yes. Apparently it worked without errors. Right?
Is it the appropriate method?
May be not.
I would use DBMS_STATS.
Search the forum/google/docs for examples

Again, use CODE tags.
Please search before posting.

Also,
>>I re - exported and gave as statistics=none
That was the crude workaround. Setting up proper NLS would work too.

Re: EXP error [message #391829 is a reply to message #391828] Fri, 13 March 2009 15:01 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hi Mahesh,

Is the below one correct for the anaylze of all the tables in the schema:

exec dbms_stats.gather_schema_stats(ownname => 'SCOTT',
options => 'GATHER AUTO', estimate_percent => 15);


Please let me know if it's correct . After all I need to do on Dev boxes and I can't play with the commands.

Only if you correct me , I'll learn from this and not do the next time , so please help me out.


Re: EXP error [message #391832 is a reply to message #391829] Fri, 13 March 2009 15:26 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> let me know if it's correct
Again,
How can I certify something like this without any idea about your
database or data or your data distribution?
If there is one solution for all the problems, Oracle could have implemented by default.
This may be a base strategy. Start from this. You may look into further options if you run into trouble.

>>I can't play with the commands
Unfortunately, You have to. Else there is no way you can learn.
Install a private database and try to understand what these options would do your database.

>>Only if you correct me , I'll learn from this.
And what if my "correction" was blatantly wrong?

Instead of relying on some random/anonymous example/advice your picked from web/forums,
Read the docs.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#sthref6735
Understand what the options can do for you.
Justify them. If you then have concerns, post here. Folks can discuss it.
Try in a safe dev/test environment.

Edit:
Removed comment on cascade.

[Updated on: Fri, 13 March 2009 15:51]

Report message to a moderator

Previous Topic: Piping STDIN to SQLLDR on Windows
Next Topic: Exporting data from 11g using 10g XE client
Goto Forum:
  


Current Time: Thu Dec 08 00:37:27 CST 2016

Total time taken to generate the page: 0.10421 seconds