@MasterPlanSoftware said:
Ever heard of a shift key or spell check?
ever heard of minding your own fucking business?
as a matter of fact, go ahead and run a spellcheck on my comment. maybe you need to go back to school
@MasterPlanSoftware said:
Ever heard of a shift key or spell check?
ever heard of minding your own fucking business?
as a matter of fact, go ahead and run a spellcheck on my comment. maybe you need to go back to school
ever tried to move a dev database to prod? or copy a prod database to a dev one? and if you need to transfert only part of the db you're fucked. you're pretty much required to write 200 lines of perl every time. exp/imp is a piece of shit compared to the competitors, expdp is even worse and there is no way to drop all the tables in a tablespace without a pl/sql script (which you have to do because imp doesn't have a proper truncate option). you can't even make a straight up copy of the whole database easily. sure you can muck around with the pfile, but it takes wayy too long for something as simple as a copy
enterprise manager is OK, if you only want to look at the main page. but even then the data it reports is consistently wrong (for exemple, it's been telling us there's only 6% left on the flash recovery area, when a select on the view says otherwise. or that no backup have been made for over 6 months when there is, and they are working, we even recovered a bd from one). the performance manager lacks a lot of useful views, oracle has been deadlocking on us and it doesn't report that anything is amiss
so going by the recommendation of "expert" Burlesso, we bought "expert" Ault script package, both "experts" seem to be closely related even if they don't disclose that fact
for 70$ we get a zip file with a bunch of .sql with cryptic names and with the sole documentation being this line at the top
/* Copyright <A9> 2004, 2008 by Rampant TechPress Inc.*/
that line is also added to an included zip file inside the zip (obviously breaking the zip)
it also include 3 files which are clearly the results of some of the sql being run, but are counted in the total number of scripts provided by the package
the "bill" we got with the zip had a link for documentation about the scripts, which only tells you how to use grep to search inside the scripts (which themselves are, as i said, totally undocumented)
yay for 20000$ of software without basic tools included, double yay for useless 3rd party "tools", triple yay for "experts"