Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    India
    Posts
    191

    Unanswered: Error in Copy Command

    Hi,
    I am trying to Create a table from remote database to local database. But while executing the copy command, i am getting error.

    COPY FROM test/test@usa_db -
    Create test -
    using SELECT * from test where 1=2

    ERROR:
    ORA-01727: numeric precision specifier is out of range (1 to 38)

    Thanks in Advance

    Thanks,
    Pagnint
    (No need to search web before posting new question)

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Error in Copy Command

    COPY FROM test/test@usa_db -
    Create test -
    using SELECT * from test where 1=2

    Try this:

    Create the database link (named mylink) to to usa_db.
    create table test as select * from test@mylink where 1=2;

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Hi ika,

    I dont want to create database link. I want to try it by Copy command
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

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