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

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

    sqlplus won't exit after alter database recover...

    hey, I'm seeing some odd behavior w/10.1.0 (linux) where sqlplus hangs on an exit after doing an: alter database recover automatic until cancel using backup controlfile; I'm old school and don't believe in rman so this is something of a problem. has anyone heard of this?
  4. DBAwhosaysNIE

    tuning performance of disk sorts (imp)

    dudes/dudettes, I am in the process of migrating some legacy 8.1.7.4 databases to 10.1.x. it looks like my bottleneck is creating indexes (disk sorts) after the rows are imported. are there parameters you can tweak to squeeze this or is pretty much limited by your storage subsystem?
  5. DBAwhosaysNIE

    alter session in an after logon on database trigger?

    before everyone warms up their flamethrowers I realize how bad this sounds but I have a situation where I am looking for the least offensive hack to deal with the following: we have a 3rd party application that backends into Oracle that is somewhat unstable (they're a windoze shop). to try to...
  6. DBAwhosaysNIE

    getting ORA-00942 on database open

    I created a new database with the scripts generated by previously using dbca. when everything finishes I get a 942 (table doesn't exist) when the database opens. it appears to successfully open and work fine (can create/user objects) but this doesn't make me particularly warm or fuzzy. has...
  7. DBAwhosaysNIE

    ugly hex substring -&gt; date -&gt; rolling average ?

    all, I have been asked to produce a report which gives the average age of records in each of a set of tables whose timestamp is the rightmost eight characters of a varchar whose value is hex unix time (sec since 1/1/1970). I have been asked to do this as a view or stored proc (re. all in SQL...
  8. DBAwhosaysNIE

    installing DBMS_XMLQUERY

    all, I have a 3rd party app that requires DBMS_XMLQUERY but I can't figure out how to install that package. I installed the XML options (they're on by default anyway) when I installed the software but when I grep DBMS_XML $ORACLE_HOME/rdbma/admin/* I get DBMS_XMLGEN, DBMS_XMLSTORE...
  9. DBAwhosaysNIE

    move the master & tempdb to another file system

    greetings! I have inheirited a S2K box that someone else set up which is the backend for a moderately important application. this morning I started getting paged that the "C:" drive was filling up. I drilled down until I found that whatever rocket scientist set up that server had put the...
  10. DBAwhosaysNIE

    using rebuildm.exe to rebuld master (lost RAID)

    I had to rebuild a disk array on which my master DB files were. I have backup of the master DB but service fails to start. initial research seems to indicate I need to run rebuildm.exe to recreate a &quot;shell&quot; master then I should be able to start service, restore my master and other...
  11. DBAwhosaysNIE

    error deleting file - sharing violation

    I am unable to delete a ~200GB file (SQL/Server backup) which is keeping me from backing up a database. have rebooted and am still getting same error. does Windows have an equivilant to the Linux/Unix lsof command to match file handles to processes? I'm posting this here instead of SQL/Server...
  12. DBAwhosaysNIE

    TNS Listener got high &amp; wandered off...

    o.k., explain this one: @05:00 EDT this morning I got a page saying the TNS Listener wasn't running on a pre-production (3rd party app being implemented)server. I attempted to restart it but got an error stack that ended (or began depending on how you look at it) with Linux Error: 32: broken...
  13. DBAwhosaysNIE

    Athlon motherboard for SuSE box

    hi! I was hoping someone could reccomend a good motherboard (something ~1.2 GHz Athlon) and/or vendor on which to build a good SuSE 7.x home workstation. SWMBO has kindly agreed to give me a &quot;budget&quot; for this project as my x-mas present and the IBM x350(s) I have at work are a little...
  14. DBAwhosaysNIE

    MTS dispatchers not registering w/TNS Listener

    I have configured a test instance for MTS and I can see that it is creating dispatcher processes and shared server processes. if I get the TCP port from v$dispatcher I can connect directly to that port and use a shared server process but I can't get them to register with my listener. if I do a...
  15. DBAwhosaysNIE

    is there an ssh/scp client for CE?

    if so who, how much, etc? I'm thinking about buying an iPAQ but my justification (/rationale:) for doing so would be if I could use it to fix work problems when traveling instead of lugging aroung a full laptop.
  16. DBAwhosaysNIE

    background processes forking as root

    hey, I have a box running 8.1.7.0.1 on SuSE 7.1 which will start an instance but will not create a database. after poking around a little I noticed that its processes (pmon, dbwr et al) were owned by root instead of oracle. I know I installed it as oracle so that's not the problem. This is...
  17. DBAwhosaysNIE

    boot disk to kickstart RH6.2 from CD?

    I downloaded the .iso for RH6.2 and burned it but can't figure out how to install from it. RH site says I need a boot disk w/kickstart file (understand principle as am familiar w/jumpstarting Solaris) but their instructions for doing so are from Linux! I understand them not wanting to promote...
  18. DBAwhosaysNIE

    DOWNgrading a database from 8.1.6 to 8.0.4

    I have to downgrade a database from 8.1.6 to 8.0.4 (license reasons/long story/don's ask) but have not had any luck using export (8.0.4 import hacks on 8.1.6 export). I know several UGLY ways I could do this (DB links, extracting DDL from export file, SQL*Loader, etc.) but was hoping there's...
  19. DBAwhosaysNIE

    to MTS or not to MTS?

    hi, all, I'm trying to find some criteria for when to switch from dedicated to MTS. Is there some relatively static threshold or is it more a function of hardware (of which we have plenty)? Can I keep pileing on user processes as long as I have idle CPU and am not swapping? Examples with...
  20. DBAwhosaysNIE

    is there a way to do hot replication with SQL*Anywhere (dbeng50)?

    we need to be able to migrate data for 3rd party app (which runs on top of Sybase) from development to testing environments. any help would be greatly appreciated...

Part and Inventory Search

Back
Top