SqlDbx Forum

garbuya

Member

Bugs in generating scripts

While generating Oracle scripts for a whole schema I noticed these problems with generated DDL for tables:
1. Tablespace for indexes is not generated at all 
    We have different tablespaces for indexes and for data, so without specifying tablespace DDL is useless
2. Tablespace for tables not generated sometimes.
3. Default values are not generated, so I'm not sure if  changed values will be generated -- for example, FREELISTS or other
    To avoid confusion it would be much better to generate ALL parms, even the default ones
4. GRANT statements not generated at all

Last edited by garbuya (2015-06-03 13:12:41)

sqldbxhelp

Administrator

Re: Bugs in generating scripts

Go to Tools->Options->Servers->Oracle and check "Use DBMS_METADATA for Scripting"