Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    20

    Unanswered: Equivalent of DBCC statements in Oracle

    while migrating from SQL server to oracle9i i need to find some work around or equivalent of few DBCC statements... Does anybody know what is the possible workaround of DBCC statments in oracle 9i...

    Thanks
    Alok

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi.

    please be a bit more clear about what u r looking for. For what MSSQL statement r u looking for an Oracle equivalent and what does that MSSQL statement do in general ?

    Greetz
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Sep 2003
    Posts
    20
    I want the equivalent of following DBCC statements:
    DBCC Useroptions
    DBCC Tracestatus,
    Traceon,
    Traceoff,
    ShowContig
    CheckDB,Checkconstraints

    If there are any inbuilts functions in Oracle for the same, then i m looking for them....

    Please help me out
    Thanks
    Alok

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    OK Now we know the names of the foreign functions. Can u tell what they do ?
    Edwin van Hattem
    OCP DBA / System analyst

  5. #5
    Join Date
    Sep 2003
    Posts
    20
    Ok so these are inbuilt commands in SQL server which we can use for diffrent purposes...
    I am looking for some equivalent inbuilt functions in ORACLE...

    DBCC CHECKCONSTRAINTS =>Checks the integrity of a specified constraint or all constraints on a specified table.

    DBCC CHECKDB => Checks the allocation and structural integrity of all the objects in the specified database.
    DBCC TRACEOFF => Disables the specified trace flag(s).
    DBCC TRACEON => Turns on (enables) the specified trace flag.
    DBCC TRACESTATUS => Displays the status of trace flags.
    DBCC USEROPTIONS => Returns the SET options active (set) for the current connection.
    DBCC SHOWCONTIG => Displays fragmentation information for the data and indexes of the specified table.

    Please help me out if anybody has any idea..

    Thanks
    Alok

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •