Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DBAwhosaysNIE

    vba to strip schema prefix from ODBC link tables

    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...
  2. DBAwhosaysNIE

    recovery strategy check

    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...
  3. DBAwhosaysNIE

    recovery strategy check

    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...
  4. DBAwhosaysNIE

    recovery strategy check

    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...
  5. DBAwhosaysNIE

    recovery strategy check

    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...
  6. DBAwhosaysNIE

    Oracle standard versus Oracle Standard one

    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...
  7. DBAwhosaysNIE

    Unix Oracle and SQL 2000

    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.
  8. DBAwhosaysNIE

    Application DBA vs. Operational DBA

    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...
  9. DBAwhosaysNIE

    Enterprise Manager

    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...
  10. DBAwhosaysNIE

    Oracle 10g on Open Power for Redhat Linux AS

    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.
  11. DBAwhosaysNIE

    Oracle 10g on Open Power for Redhat Linux AS

    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...
  12. DBAwhosaysNIE

    Oracle 10g on Open Power for Redhat Linux AS

    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...
  13. DBAwhosaysNIE

    Oracle 10g on Open Power for Redhat Linux AS

    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...
  14. DBAwhosaysNIE

    Any special issues in 8i to 10g migration?

    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...
  15. DBAwhosaysNIE

    Last logon of a user

    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...
  16. DBAwhosaysNIE

    weird &quot;inconsistent datatype&quot; error

    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...
  17. DBAwhosaysNIE

    weird &quot;inconsistent datatype&quot; error

    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...
  18. DBAwhosaysNIE

    Oracle 10g Hardware/Software Requirments

    ...weather.com? I am not aware of a large site (other than microsoft.com) that uses windoze. 3. not sure what you mean by this but once you learn *nix you'll find it's WAY easier to manage a large distributed environment. that's one of the main reasons large shops use it. we have > 400...
  19. DBAwhosaysNIE

    Oracle 10g Hardware/Software Requirments

    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...
  20. DBAwhosaysNIE

    Oracle 10g Hardware/Software Requirments

    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...

Part and Inventory Search

Back
Top