I think you'd be better off with the Tools -> Database Export (the name is
misleading) option? Also, includes GRANTS.
My problem is that on the databases I've been supporting lately I don't
have execute on DBMS_METADATA. Only SELECT ANY DICT. So, tools that
generate DDL from DBMS_METADATA don't work for me, sadly. However, there
are some tools that use dictionary views to get the DDL. Sometimes there's
no school like the old school.
Andy K
On Fri, Mar 8, 2019 at 12:06 PM Matt Adams <MAdams@xxxxxxxxxx> wrote:
SQL Developer 18.3.0.227
Steps I perform:
Start a schema browser.
Choose a schema other than one I logged in as
Choose Packages (note – package bodies is not an option)
Highlight all packages (about 50 to 60).
Option 1 - Right click -> Export -> (change file name for output) Next ->
Finish
End up with one package header in file
Option 2 -> Right click -> Quick DDl -> Save to file
End up with all package headers in file
Still haven’t figure out how to get package bodies generated
*From:* Jeff Smith <jeff.d.smith@xxxxxxxxxx>
*Sent:* Friday, March 08, 2019 11:09 AM
*To:* Matt Adams <MAdams@xxxxxxxxxx>; Kellyn Pot'Vin-Gorman <
dbakevlar@xxxxxxxxx>
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* RE: RIP DDL Wizard
Developer, but I’m having difficulties with that.At the moment, I’m using one of the features of Oracle’s SQL
Like…?
*From:* Matt Adams <MAdams@xxxxxxxxxx>
*Sent:* Friday, March 8, 2019 10:36 AM
*To:* Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx>
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* RE: RIP DDL Wizard
If there’s another tool that works as well as DDL Wizard, I don’t know
about it. All I want is a license key to use to most recently available
version. I’m not asking for any support. I wouldn’t think that they would
care if they don’t have to support it, but obviously there’s more to it
than that. At the moment, I’m using one of the features of Oracle’s SQL
Developer, but I’m having difficulties with that.
I’d also like them to bring back the DataBee sub-setting tool they got
from Net 2000 LTD too. I had finally convinced this place to buy it, only
to discover Redgate had bought and buried it 4 months earlier. I’ve had a
few discussions with Redgate about this tool, but they apparently have no
interest in selling or supporting it.
Matt
*From:* Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx>
*Sent:* Friday, March 08, 2019 10:16 AM
*To:* Matt Adams <MAdams@xxxxxxxxxx>
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: RIP DDL Wizard
Net 2000 was a huge acquisition by Redgate, giving them the masking tool
they desired for their SQL Clone to go SQL Provision product. I wouldn't
be surprised if they are the lead behind this. The question would be, is
there another tool from them that is similar that competes with it? Now
that I don't know. I'm more familiar with their cloning and masking
products as that was in my wheelhouse while I was at Delphix.
Their marketing just reached out to me yesterday about presenting with
them, so I did ask about a PM that I could talk to about this topic, so let
me know if getting more info on it is still of interest.
Hope this helps,
*Kellyn Pot'Vin-Gorman*
DBAKevlar Blog
<https://link.zixcentral.com/u/53acb120/ACCreLxB6RGt4VP-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_dcfe2997_etEHG7VB6RGEO94Fh3soMg-3Fu-3Dhttp-253A-252F-252Fdbakevlar.com%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DX30sKT2Igw8FjSvAc-10fN5uuWOOvlDmUQf88CT8J1E%26e%3D>
President Denver SQL Server User Group
<https://link.zixcentral.com/u/9b3f4285/0IGreLxB6RGt4VP-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_66972249_TiAIG7VB6RGEO94Fh3soMg-3Fu-3Dhttp-253A-252F-252Fdenversql.org-252F%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DS094van8iXJAAbw_ix8Qw36KdYnT4G4jzEOYw66pM2c%26e%3D>
about.me/dbakevlar
<https://link.zixcentral.com/u/8b2e3526/bNGreLxB6RGt4VP-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_bcd9386e_PL0JG7VB6RGEO94Fh3soMg-3Fu-3Dhttp-253A-252F-252Fabout.me-252Fdbakevlar%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DAG5kesYj5Z-OCTUNqSglUHabfSxmi18NzchtFQ6aZVM%26e%3D>
On Fri, Mar 8, 2019 at 10:10 AM Matt Adams <MAdams@xxxxxxxxxx> wrote:
It may have been discontinued by Net 2000 LTD at Oracle 10, but I was
using it with Oracle 11 and 12 up until 2 months ago with no problems.
Matt
*From:* Jacek Gębal <jgebal@xxxxxxxxx>
*Sent:* Friday, March 08, 2019 9:55 AM
*To:* Jeff Smith <jeff.d.smith@xxxxxxxxxx>
*Cc:* dbakevlar@xxxxxxxxx; Matt Adams <MAdams@xxxxxxxxxx>;
oracle-l@xxxxxxxxxxxxx
*Subject:* Re: RIP DDL Wizard
I got some feedback from a colleague at RedGate.
"... Just asked internally. This tool was discontinued at Oracle 10
anyway, even by Net2000.
So hardly surprising that it's not available ..."
On Fri, 8 Mar 2019, 14:36 Jeff Smith, <jeff.d.smith@xxxxxxxxxx> wrote:
I’ve never heard of it, but I can imagine it’s use cases.
What could it do that SQLcl’s DDL command could not? Maybe there are some
ER’s we could address on our tooling side to fill any gaps they left
behind.
*From:* Jacek Gębal <jgebal@xxxxxxxxx>
*Sent:* Wednesday, March 6, 2019 5:16 PM
*To:* dbakevlar@xxxxxxxxx
*Cc:* MAdams@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
*Subject:* Re: RIP DDL Wizard
utPLSQL was recently supported by RedGate and we're getting interest from
their side in unit testing for Oracle PL/SQL & SQL.
It seems strange that they are giving up on some of their products for
Oracle DB given their overall interest in DB DevOps and CI/CD.
Cheers
Jacek
On Wed, 6 Mar 2019 at 20:31, Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx>
wrote:
I'm sorry to hear this and will be giving the folks over there a hard time
about it. Although Redgate doesn't have the following on the Oracle side
like they do on the Microsoft SQL side, its still a shame to see it go.
With their huge impact on the DevOps, CI/CD with their SQL Provision,
(think thin clone with data masking) product plugged in with their SQL
Toolbelt, they've got quite the customer base, with Oracle supported stuff
just a side gig, (same with MySQL and other db platforms).
Good to know about DDL Wizard.
*Kellyn Pot'Vin-Gorman*
DBAKevlar Blog
<https://link.zixcentral.com/u/1015ebb4/Jl2xeLxB6RG8r1P-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_435070df_JOHYLrJB6RGTLOHm9e-5F1Kg-3Fu-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fdbakevlar.com-2526d-253DDwMFaQ-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253DjaO-2DpXepBzSx98nP01x-2DoAIhEMzgMh8Fn7mQU5Vurwg-2526s-253DVyqemNfku-2DaSC-5Fos5v3yw9HUOra-5FwrsvVZw6jlQhmwA-2526e-253D%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DaaB_GnUdndLhiJxeu4cMWzwt9KeVFmOmSKkdVBiyOW8%26e%3D>
President Denver SQL Server User Group
<https://link.zixcentral.com/u/eb92455e/fq6yeLxB6RG8r1P-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_fa8662d4_aBXZLrJB6RGTLOHm9e-5F1Kg-3Fu-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fdenversql.org-5F-2526d-253DDwMFaQ-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253DjaO-2DpXepBzSx98nP01x-2DoAIhEMzgMh8Fn7mQU5Vurwg-2526s-253DIOWH2Ub2QnlmU3qd3iUeACipTv6bs7zL6bvSMQ2NLkA-2526e-253D%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DlHj0z6ml3_IvuQGB2CYLZz503gpYCocX1idge-PicZg%26e%3D>
about.me/dbakevlar
<https://link.zixcentral.com/u/dcce25a5/WPKyeLxB6RG8r1P-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_19b0a4e6_fkXZLrJB6RGTLOHm9e-5F1Kg-3Fu-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fabout.me-5Fdbakevlar-2526d-253DDwMFaQ-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253DjaO-2DpXepBzSx98nP01x-2DoAIhEMzgMh8Fn7mQU5Vurwg-2526s-253DSlha4BNoOUQkvO2OCT5V-5FMPfbI-5FtgW9H8HIdYamqL6c-2526e-253D%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3D3-IaQaz-SviEDCGZQwIXFuiR7exkgnJwbl7ooUUrTAA%26e%3D>
On Wed, Mar 6, 2019 at 3:03 PM Matt Adams <MAdams@xxxxxxxxxx> wrote:
I just found out that Redgate (the purchasers of the DDL Wizard developers
Net 2000 LTD.) will no longer supply license keys for any version,
including the free/unsupported version. Which means that while the
software can still be downloaded, it’s useless.
I know that DDL Wizard has largely been replaced by the DBMS_METADATA
package and features built into software packages like TOAD and SQL
DEVELOPER, but I still used it on a regular basis and still loved it.
Unfortunately, my previous laptop has died, and I cannot run DDL Wizard on
the new one.
This tool was of tremendous benefit in it’s heyday and I for one will miss
it.
Good bye DDL Wizard. Rest in Piece.
**** This communication may contain privileged and/or confidential
information. If you are not the intended recipient, you are hereby notified
that disclosing, copying, or distributing of the contents is strictly
prohibited. If you have received this message in error, please contact the
sender immediately and destroy any copies of this document. ****
**** This communication may contain privileged and/or confidential
information. If you are not the intended recipient, you are hereby notified
that disclosing, copying, or distributing of the contents is strictly
prohibited. If you have received this message in error, please contact the
sender immediately and destroy any copies of this document. ****
**** This communication may contain privileged and/or confidential
information. If you are not the intended recipient, you are hereby notified
that disclosing, copying, or distributing of the contents is strictly
prohibited. If you have received this message in error, please contact the
sender immediately and destroy any copies of this document. ****
**** This communication may contain privileged and/or confidential
information. If you are not the intended recipient, you are hereby notified
that disclosing, copying, or distributing of the contents is strictly
prohibited. If you have received this message in error, please contact the
sender immediately and destroy any copies of this document. ****
