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!

  • Congratulations dencom 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: *

  • Users: oracleSQLdba
  • Content: Threads
  • Order by date
  1. oracleSQLdba

    Table too wide.

    We're getting the "exceeds the maximum numberof bytes per row (8060)." error in sql 2000. Does anyone have any kb articles , whitepapers, something else from Microsoft which acknowledge the problem AND indicate it's ok to proceed? The one article I've found from MSFT simply notes that...
  2. oracleSQLdba

    spool question

    I want to spool my results without the SQL> in my results: SQL> col1, col2, col3 etc. How can I get rid of the SQL> in the spool output?
  3. oracleSQLdba

    POP3 question

    Does server 2003 come with a built in POP3 mail server?
  4. oracleSQLdba

    SEQUENCES

    How can I tell the sequences owned by my Schema? I'm looking for the SQL statement... Thanks
  5. oracleSQLdba

    Daylight Savings Time question

    Anyone tested oracle 7.3.4 on AIX, or anything else for that matter, against the March Daylight Savings time change??
  6. oracleSQLdba

    sp_delete_backuphistory

    Has anyone here found a way to speed up sp_delete_backuphistory?
  7. oracleSQLdba

    BCV with SQL Server

    Anyone using BCV' with SQL Server 2000 or 2005? I've got some questions....
  8. oracleSQLdba

    Help!! Customer hasn't upgraded in 10 years!!

    This error in the event log. Oracle 7.3.4.5.0 on aix. Can someone tell me what I need to do. I've googled it and one response was to drop the rollback segment and recreate. I just want to verify first. BTW, how do you do that if that's the fix? Thanks. ALTER ROLLBACK SEGMENT "R02" STORAGE (...
  9. oracleSQLdba

    Deadlocking

    does anyone know if deadlocks are reported in the sql 2000 error log by default?
  10. oracleSQLdba

    Removing a db

    How do I remove a 9i db from solaris with multiple databases with a single oracle_home?
  11. oracleSQLdba

    slow cursor / sp_cursorprepexec

    I've the following which returns as slow as molasses. I've searched the msft kb and it seems to be saying the oledb or ado settings for the cursor are not set to the default. How / where can I check this? Many thanks. set @P1=7 declare @P2 int set @P2=180150011 declare @P3 int set @P3=16...
  12. oracleSQLdba

    Describing security

    Can I check the dba_users or other views in Oracle 7.3.4.x to show me security. I cannot remember... Thanks.
  13. oracleSQLdba

    V$ view

    Is there a V$ view that will show me the installed version and patch level??
  14. oracleSQLdba

    DataGuard question

    In data guard 9i implementation is the target database available for read operations at any point / all the time?
  15. oracleSQLdba

    RMAN 9i catalog import to 10g

    I was dumped a set of Solaris servers this morning. Lucky me. Anyway, the vendor is taking their servers in 3 weeks and are offering to export the server data from the catalog server so that I can import it into a new server that I have to build. Can this be done moving from 9i to 10g along...
  16. oracleSQLdba

    EMC in a cluster /SRDF CE

    We are planning on deploying an Active/Active cluster with EMC SRDF CE across two data storage devices. We'll use SRDF to keep the two data stores in sync. What I'm unclear on is how / whether the quorum is split across two data stores with SRDF CE. Please advise....
  17. oracleSQLdba

    9.2.07

    Can someone tell me where I can find the readme which lists the changes in Solaris 64bit ,9.2.07 database patch release from 9.2.06 Many thanks.

Part and Inventory Search

Back
Top