SqlDbx
You are not logged in.
Pages: 1
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)
Offline
Go to Tools->Options->Servers->Oracle and check "Use DBMS_METADATA for Scripting"
Offline
Pages: 1