EXP error [message #391824] |
Fri, 13 March 2009 14:33 |
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 |
|
Mahesh Rajendran
Messages: 10708 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 |
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 #391829 is a reply to message #391828] |
Fri, 13 March 2009 15:01 |
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 |
|
Mahesh Rajendran
Messages: 10708 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
|
|
|