Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009

    Unanswered: extra space in file_location for alter command

    I do below alter command
    alter tablespace RCA_MB_IDX add datafile '/gxsdb/database/oradata5/RCA/RCA_REF_MB_IDX_01.dbf ' size 1024M

    But there is extra space in the file location '/gxsdb/database/oradata5/RCA/RCA_REF_MB_IDX_01.dbfX'
    I mark X for that space ...

    The command is commit .

    But there is problem when do backup the file cannot be find since there is extra space after ".dbf"
    How can I fall back ???
    Any idea how I can fix it ????

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    Try 'moving' the file to a new location i.e. one without the extra space.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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