User Profile

Collapse

Profile Sidebar

Collapse
pchadha20
pchadha20
Last Activity: Nov 13 '08, 12:31 PM
Joined: Oct 11 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pchadha20
    started a topic Not able to user synonyms based on dictionary tables like
    in Oracle

    Not able to user synonyms based on dictionary tables like

    Hello Guys,
    I am Not able to user synonyms based on dictionary tables like
    ..when i write the command like

    SELECT * FROM USER_SOURCE

    then error comes like
    ERROR at line 1:
    ORA-00980: synonym translation is no longer valid

    and when i write

    DESC USER_SOURCE

    then it exit from oracle and session gets close.
    See more | Go to post
    • pchadha20
      started a topic How to increase the default row size in sql server 2000 only
      in SQL Server

      How to increase the default row size in sql server 2000 only

      Hi, Guys.
      I am in bit trouble.I am importing the table from mysql to sql server which has having nearly 65000 records.
      I starts the import of table by import/export utility.But when the records reaches 65000, the error message came.."THIS TABLE HAVING ROW SIZE 8190 WHICH IS EXCCEDING THE DEFAULT SIZE OF 8060".
      So please let me know how to over come this problem..

      I CAN'T UPGRADE SQL SERVER SO GIVE SOLUTION...
      See more | Go to post
      • pchadha20
        started a topic How to increase the default row size in sql server
        in SQL Server

        How to increase the default row size in sql server

        Hi, Guys.
        I am in bit trouble.I am importing the table from mysql to sql server which has having nearly 90000 records.
        I starts the import of table by import/export utility.But when the records reaches nearly 60000, the error message came.."THIS TABLE HAVING ROW SIZE 8190 WHICH IS EXCCEDING THE DEFAULT SIZE OF 8060".
        So please let me know how to over come this problem..

        Thanks in Advance to all of you....
        See more | Go to post
        • pchadha20
          started a topic How to single numeric values from a field in a table which has multiple numeric value
          in Oracle

          How to single numeric values from a field in a table which has multiple numeric value

          How to single numeric values from a field in a table which has multiple numeric value in a field of a table.And that table contains thousands of records.

          Suppose we have a table customer having fields like
          CUST_ID, CASTE, AGE etc.
          101 (12,89,76,34,66 ,90,36) 23
          128 (27,45,71,211,4 3,107,67,451) 26
          117 (11,23,32,265,1 42,88,67,98) 30
          ............... ............... ............... ..................
          See more | Go to post
          • pchadha20
            replied to help me to find the Host string for Oracle
            in Oracle
            Thanks for reply..I will try it out..

            pchadha20...
            See more | Go to post

              Leave a comment:

            • pchadha20
              started a topic help me to find the Host string for Oracle
              in Oracle

              help me to find the Host string for Oracle

              Hi,
              I have forget the host string of oracle.
              Now i am facing difficulty to login to oracle.
              try to help to get solution

              Regards.
              pchadha20
              See more | Go to post
              No activity results to display
              Show More
              Working...