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

Thread: Transportable Tablespace

  1. #1
    Join Date
    Oct 2001
    Posts
    127
    I am trying to export one tablespace ,i have given the export parametrs like this
    EXP \'sys/change_on_install@TEST AS SYSDBA\' PARFILE=D:\RAD\EXPAR
    It is giving me the following error:
    LRM-00108: invalid positional parameter value 'AS'
    Can someone tell me how to specify the correct parameters.
    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Enter the following command and try it out

    exp "'sys/change_on_install@test AS SYSDBA'" parfile=d:\rad\expar

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    oracle-support@indiatimes.com

    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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