Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2009-11-05 : 14:33:14
|
| I've been dropped in the deep end..."Oh won't this be great for you...you'll be the only one with ALL of these skills"I go to different Oracle boards, and not for nuthin, the people are the worstI asked once how to do a database backupanswers were like...what type, does the database exists, you don't even know how to ask the right questionWELL...I THINK WE know how to ask a basic questionHOW DO I BACK UP AN ORACLE DATABASE (Schema/instance/what have you)All I want is a place to look and a sample backup (EXPORT) command syntaxLooked it up one place and I saw 40 pagespainful, just painfulTHANK YOU SQLTEAM FOR ALL OF THE GREAT HELP OVER THE YEARSBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-11-05 : 15:25:54
|
| I will be diving into an Oracle project next week, but thankfully only development and not admin. I'll still have to deal with the PSQL conventions and restrictions though, which sux.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-11-05 : 17:11:35
|
| red gate started a new forum for oracle at:http://www.oracleoverflow.comtry there.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-11-06 : 15:52:16
|
| By the way, Brett. Yer welcome. ;-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-11-06 : 16:45:32
|
| I guess that would be baneI can handle the PLSQL stuff without to much problem..did that beforeIt's a "We're not in Kansas anymore" kind of thing..and I cut my teeth on DB2...but the Actual SA/ADMIN part...no thanksBut then again...it's going to become...for read/only, reporting database, 1 or 2 users (me and someone else)...soooooooIf I f up...I still need to get back...but no one wiull notice until I doI just want to be able to get backAnyway...cheerio....must be 9:45 in London...the blitz going on yet?Have a pint for me...none of the bland American garbage ind youAnd have a good weekendBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2009-11-09 : 15:30:48
|
| This is no help, and I am sure you already know more than I ever did, but here goes nothing:When we first moved up from our boys-own ISAM file system to a grown-up-SQL system - to keep our customers happy - we decided [in the '80s] that we had to support Oracle and Sybase; we also decided to support Watcom for small customers [Watcom later become PowerBuilder Lite DB (or somesuch) and Power-Builder was bought by Sybase, so that became Sybase Anywhere DB (or somesuch)].A prospective, but important, client asked if we could support Microsoft's DB. We were keen on MS products so said "yes" - not to mention the fact that it looked like re-branded Sybase. Except it was the only one that did not support multiple concurrent result sets per connection, which was the cornerstone of how we had built our APP.But MS entering the DB market was a turning point. All the big Times-top-100, or Forbes-top-100, companies relaxed their "Brand-X database only" policy to include the MS database - because lots of vendors bravely [so it seemed to us] said "We are now only offering the MS Database" - alhough we continued to try to support them all.Within a year all bar a few of our customers had made the "We now also support the MS database" statement. So we started to question why the "few" still required "Oracle [or whatever] only". Indeed, a number of our clients' IT departments widened their DB support but the department we were dealing with still unilaterally stuck to Oracle - why?.We continued to do some Oracle work for those customers before calling "time". At the time I thought that a) the MS database was a good thing for us [familiar territory] but b) it was the "poor relation" to the Big Database (read: "Oracle"). I was wrong.Each time a client asked me to come and implement something in Oracle I would faithfully attend, work alongside their long-standing, skilled, Oracle DBA, and ... well, I can't quite describe it ... I either "Marvelled" at what they went through, or thought they were completely "stupid". But, either way, I don't remember thinking that the time was "well spent"My perception had been that Oracle was "the same on all platforms" and yet we had to solve, for example, what sort of line-ending their platform needed for our Bog Standard SQL scripts. So our Windows/DOS style CHAR(13)+CHAR(10) often had to be converted to plain CHAR(10) [even for, IIRC, SQL Server running on a Windows O/S on DEC kit]. We had various command-line-tools that would do that, but it still took an hour or two's messing about on 100's of patch files. Why?And then there would be more smoke & mirrors. "Can we build a backup task?" "Sure" ... "Database is used in all timezones, can we backup without taking the DB offline" .... "Ermmm ... we'll need to script every table to backup ...XXX ..." - I'm sketchy on the details, because I never really understood WHY ... but it took AGES to build the script and every time we added a table took MORE AGES to adjust the script (was my client at-risk on the tables we were not backing up after the upgrade?) ... OK, so in SQL Server maybe using the Backup Wizard put the client at some risk, but it was eazy-pezy, but the database was backed up AND you could keep using it whilst the backup was running (SQL 6.5 ...)Long-story-short: my last experience with Oracle was in the late 70's, early 80's (maybe a bit later), so it may have changed, but at the time I looked up to Oracle - like a small boy drooling and hankering after a Lamborghini or Ferrari - but on reflection: Why? Why so hard? Why so obscure?We ditched Oracle at that point, and lost two of our best clients, but to this day I think that it was their loss. Their IT people were very happy with our application; their company's IT wanted to support non-Oracle solutions; but the heads of the department we were dealing with thought there must be something inherently wrong with us that we were not supporting Oracle.Bollocks to themn! |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-11-09 : 15:42:08
|
| o, no, I really appreciate the storyAnd EVERY Oracle DBA I encounter must be trained on how to blow smokeSeriously, you can never get a straight answer out of themEither they've all joined a masonic lodge, OR they are so over their heads with all the BS that is Oracle, that they don't want to appear to be too stupid to liveIn any case, Like I mentioned before, I got the package/proc thing down...or at least enough to be dangerous....I just need to read up on Admin nonsenseBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-11-09 : 16:09:59
|
| Great story.Slightly off-topic perhaps, but similar: I once worked with a guy who swore up and down how superior Unix was as an operating system. I then watched him spend, literally, 45 minutes attempting to get a CD to eject on his Unix box. I said, can't you just push the button the drive? Nope, won't work on Unix. How about poking a paperclip into the eject hole? Nope, won't work either...just give me a few more minutes to set up the drive and get it mounted...Oracle DBAs seem much the same to me.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
|
|
Oracle..the ban of my existence