Results 1 to 2 of 2

Thread: Dts

  1. #1
    Join Date
    Jul 2004

    Unanswered: Dts

    Hi everybody

    I have created tables in oracle 9i under a user using DTS in SQL Server. (i have exported from sql server to oracle 9i using DTS) . When i query select * from tab , it list al the tables created . But when i desc the structure of table or select * from table_name ,it shows object or view does not exist. what will be the problem ?
    pls reply

  2. #2
    Join Date
    Nov 2002
    Well this is more of an Oracle question...but I think the answer lies in the fact of the "user" (which in sql server is like the owner) who created the table.

    Plus I wouldn't do it that way...

    I would create all of my objects using DDL, bcp the data out to a pipe delimited file, copy the data to the Oracle box, and then use sqlLoader to populate the table.

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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