Results 1 to 3 of 3

Thread: Export Problem

  1. #1
    Join Date
    Sep 2004

    Unanswered: Export Problem


    Can we take export of table created under extenally identified users in database using different userid in export statement ???

    SQL> show user
    SQL> select table_name, owner from dba_tables where table_name like 'ABC' ;

    ------------------------------ ------------------------------

    Tried to take export of table ABC using login oracle10g & export statment:
    exp userid=/ tables=abc file=1.dmp, got error -

    ==> exp userid=/ tables="OPS$ORACLE"."ABC" file=1.dmp

    Export: Release - Production on Mon Mar 10 14:43:28 2008

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to: Oracle Database 10g Enterprise Edition Release - Production
    With the Partitioning, OLAP and Data Mining options
    Export done in US7ASCII character set and AL16UTF16 NCHAR character set
    server uses AL32UTF8 character set (possible charset conversion)

    About to export specified tables via Conventional Path ...
    EXP-00010: OPS is not a valid username
    Export terminated successfully with warnings.

    Any suggestions to achive this?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    I have a couple of comments about the posted problem & possible solution

    I would have used OWNER= parameter in addition to TABLES=

    In some Operating Systems the dollar sign character is a "metacharacter" on the command line & must be delimited when actually desired.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2003
    Washington DC area

    Cool import and cleanup

    I have a 2 tables. One in production, the other in a archive.

    gid num
    grid num
    accid num
    date date null

    I need to update productions without creating dupes?

Posting Permissions

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