Search results for query: *

I used to have code to do this years ago but have need for it again. basically if you create a bunch of link tables (from Oracle in my case) it puts <schema_> as a prefix to <table_name>, i.e. you end up with schema_table_name. does anyone have a example or link to an example of the vba to...

Cross-Platform Tablespace Conversion" o.k., that's kind of cool (we don't use windoze but solaris<->linux could be useful) but (at the risk of being obstinate) what's the advantage of a TTS over exp/imp if you can't reuse the physical dbf? in fact if it is (by definition) having to physically...

mufasa/sem/carp (/others w/7.3 & < experience): is there acually anything you can do w/rman that you can't from a shell & sqlplus? I have looked at it in the past (years ago) and it seemed to me all it did was abstract the alter tablespace/database/system (& cp/dd shell) commands from the...

I'm confused: "The biggest advantage that you are missing is the ability to keep your database up while your backup (rman) is running" implies you think you have to use rman to make a hot backup (sad) but: "I have one server, in archive log mode, that I am using cron, compress, and a mapped...

I guess I'm "old school" (OCP'd on 7.3 in '98) but I don't /have never seen a real compelling reason to use rman. I'm not saying it's "bad", I'm just a "KISS" guy by nature and like to see the gears turning w/my own eyes. I've yet to find anything I can't do as or more reliably w/bash, sqlplus...

SE One also limits you to two CPUs. you can squeeze a LOT out of two CPUs if you know how to architect but if your PHBs think you have to have quad (or more) you need full standard (or enterprise). FWIW, "one" is purely a pricepoint, not a product. when you buy it the CD pack is the same one...

I'd use PERL and DBI to write an autonomous "broker" daemon. there's no elegant way to do this. any solution is going to be something of a homebrew hack.

I would use a slightly different term for tha "application" DBA: development DBA. when I hear "application DBA" I think someone who administers Oracle Applications (ERP, CRM, etc.) which I (personally) don't consider to be a DBA at all. in our shop the development DBA works with architecture...

steven, you seem like an intelligent dude... why do you want to go and use a GUI? it's funny to see how people's attitudes toward OEM have changed over the years. when I started on Oracle in '97 (late 7.3/early 8.0) no self-respecting DBA would be caught dead using it. my "master" would...

they do (IBM Opteron) or at least did... we have eight of them, x325 - not sure what current model #s would be. we're buying mostly HP now (DL145, 385, etc.) though Sun is finally starting to get their prices in line.

yes, our Oracle boxes are ~50/50 Opteron/Xeon. love them! (Opteron) if you can architect for horizontal scaling (replication, layer 7 switching, etc.) I think dual Opteron boxes are definitely the best value right now. I'm not anti-Intel (they've been good to us over the yrs too), just pro...

we're >95% SuSE of which about 2/3 is on xeon and about 1/3 is Opteron. actually my support comment (re: lack thereof) was directed at Oracle. we had IBM servers for a few years (still have ~75) and I have nothing but good things to say about their support. we used to have websphere and that...

just out of curiosity why do you want to run Oracle on that stack (linux on POWER)? I'm certainly not anti-POWER and am very pro-linux (have run Oracle in production on it for > 4 yrs) but from my experience if you're on a platform outside their "core" you're pretty much on your own for...

I did this a little over a year ago for our order entry system and it went pretty smoothly. so far my only complaints are personality quirks like connect internal is no longer an option (I know I shouldn't have been doing it for a while but most of my scripts were written on 7.3). it also...

if you don't have auditing turned on your options are pretty limited. if you have an old fashioned client/server type architecture the listener log will tell you what host connected when to what instance but not what Oracle user they connected as. that may allow you to trace access to...

it looks like it is a backward (in)compatibility issue w/the 10 client. I rolled the client back to 9.1 and it works (so the application admin tells me). guess I'll log a tar on this and see if they can fix it. I don't mind running the 9 client but really ${expative} me off that this has drug...

I am working w/a "shrinkwrap" vendor of ours to get them to certify their app on 10 and am getting a weird error: their application tries to do a (sanitized for security/NDA): insert into table (col1, col2, col3, col4) values(1,:1,'abc',:2) returning col2 into :3 and gets a "ORA-00932...

AH! I'm going to go out on a limb and say 7.1. that was the only 7.x I didn't have to hack to get 8.1 to fresh install. I would be seriously impressed if you said 7.3 (and weren't lying;) 1. linux does have security updates. the difference is unless you're upgrading the kernel you don't...

not sure if you'll be able to answer this but what version of SuSE did you get 8.1 (Oracle) to install on? most of the newer distos come with a newer glibc that 8.1 will not link against. did you (or someone) downgrade glibc or are the newer ones more backward compatible? what...

FWIW my wife's in sales at Oracle and I have semi-seriously talked to some of her people before about hiring me as a consultant to go around and do exactly this: help their M$ customers convert to linux. I don't understand why they're not pressing that more (maybe fear that people will take...