DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXPORT Transportable Tablespace

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    When I run the following export command with I get the following error:

    exp system/manager@dev1 parfile=/usr/local/oracle/export/export_tablespace.parfile


    EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
    EXP-00000: Export terminated unsuccessfully


    The following is my EXPORT PARFILE:

    FILE=/usr/local/oracle/export/export_tablespace.dmp
    TABLESPACES=(USER_DATA, USER_IDX,APP_DATA)
    TRANSPORT_TABLESPACE=Y

    P.S.: I did make these tablespaces READ ONLY.
    (Oracle 8.1.6 SunSolaris 5.8)


    Thanks in advance! Hope someone would respone ASAP....

  2. #2
    Join Date
    Nov 2000
    Posts
    6

    Thumbs up

    try connect as

    exp system/manager@dev1 as sysdba parfile=xxxxxxx......!

    hope it will help..

    Bye
    Mani





Posting Permissions

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


Click Here to Expand Forum to Full Width