|
-
Thanks for that!
DBMS_STATS.CREATE_STAT_TABLE it is.
I was using O'Reillys Oracle SQL Tuning pocket reference by Mark Gurry for my syntax. So definitely a typo on page 96!
Davey, I am trying to keep a copy of my existing statistics, before a big upgrade. CREATE_STAT_TABLE is just to set up the table to store this information. I will then run DBMS_STATS.EXPORT_SCHEMA_STATS, to have a copy of current stats before upgrade.
Thanks again.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|