Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore
    Posts
    2

    Unanswered: Exporting Tables with mixed case and special characters

    Hi,

    I have a problem in exporting a table with mixed case and special characters through the parameter file.

    I got the following information from the Oracle MetaLink
    Ø Export not supporting the tables with mixed case was an Oracle
    bug. The problem got addressed in Oracle version 9.2.0.1.0.
    Ø Use the following syntax to export the table with mixed case
    To export a table with Table name “Test%Mixed”, use the following syntax,
    exp system/manager TABLES='\"USER1.Test%Mixed\"'
    This syntax works fine when used in the command prompt mode.
    My problem is, if I have the same syntax in the parameter file and try exporting through the parameter file, I get the following error : “EXP-00010:\”USER1 is not a valid user name”.

    My parameter file looks like this:
    GRANTS=Y
    INDEXES=Y
    ROWS=Y
    CONSTRAINTS=Y
    COMPRESS=N
    TABLES=('\"USER1.Test%Mixed\"')

    Please suggest me an appropriate syntax to be used in the parameter file for exporting a table with mixed case and special characters.

    Thanks,
    Malavika

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you copied the example exactly.
    You don't have a schema called USER1

    you need to specify each individual table that YOU have.

    USER1 = owner
    TEST = table name
    then use the %mixed to satisfy export
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Feb 2004
    Location
    Bangalore
    Posts
    2

    Export of a table with mixed case

    Hi,


    I have gone through the reply from The_Duck. Thanks for the same.

    But, I think I have confused the users by giving the table name as “Test%Mixed”. It is not that I want to export all the tables starting with Test and ending with Mixed.
    My table name itself is “Test%Mixed”.
    To avoid any further confusions, please consider my table name as “TestMixed”. I have the same problems exporting this table through parameter file with the following syntax, TABLES = (‘\”USER1.TestMixed\”’). As earlier mentioned, this syntax works fine in the command line mode.
    Could you please suggest me a solution for this?

    Thanks,
    Malavika

Posting Permissions

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