Re: RIP DDL Wizard

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_at_equian.com> 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_at_oracle.com>
> *Sent:* Friday, March 08, 2019 11:09 AM
> *To:* Matt Adams <MAdams_at_equian.com>; Kellyn Pot'Vin-Gorman <
> dbakevlar_at_gmail.com>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* RE: RIP DDL Wizard
>
>
>
> >> At the moment, I’m using one of the features of Oracle’s SQL
> Developer, but I’m having difficulties with that.
>
> Like…?
>
>
>
> *From:* Matt Adams <MAdams_at_equian.com>
> *Sent:* Friday, March 8, 2019 10:36 AM
> *To:* Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
> *Cc:* oracle-l_at_freelists.org
> *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_at_gmail.com>
> *Sent:* Friday, March 08, 2019 10:16 AM
> *To:* Matt Adams <MAdams_at_equian.com>
> *Cc:* oracle-l_at_freelists.org
> *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_at_equian.com> 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_at_gmail.com>
> *Sent:* Friday, March 08, 2019 9:55 AM
> *To:* Jeff Smith <jeff.d.smith_at_oracle.com>
> *Cc:* dbakevlar_at_gmail.com; Matt Adams <MAdams_at_equian.com>;
> oracle-l_at_freelists.org
> *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_at_oracle.com> 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_at_gmail.com>
> *Sent:* Wednesday, March 6, 2019 5:16 PM
> *To:* dbakevlar_at_gmail.com
> *Cc:* MAdams_at_equian.com; oracle-l_at_freelists.org
> *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_at_gmail.com>
> 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_at_equian.com> 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. ****
>

--
http://www.freelists.org/webpage/oracle-l