Oracle on Netware, Please Help !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle on Netware, Please Help !

  1. #1
    Join Date
    Jun 2002
    Posts
    5

    Unhappy

    Hi,
    I need help, I am using Oracle 8.1.5 on Novell Netware 5, the following script runs quickly and ends with no datafile(s) being copied, what is wrong? I tried COPY.NLM and OCOPY81.NLM
    *** Script ***
    alter tablespace FIN_APPS begin backup;
    copy ORACLE:ORANW815\APPS\DATA\FIN_APP1.DBF BACKUPATA
    copy ORACLE:ORANW815\APPS\DATA\FIN_APP2.DBF BACKUPATA
    alter tablespace FIN_APPS end backup;

    alter tablespace SALES_APPS begin backup;
    copy ORACLE:ORANW815\APPS\DATA\SALES_APP.DBF BACKUPATA
    alter tablespace SALES_APPS end backup;
    *** Script ***

    What could be the problem? Pls Help!!!
    Mike.
    Share on Google+

  2. #2

    Wink Copy

    copy ORACLE:\ORANW815\APPS\DATA\FIN_APP1.DBF BACKUPATA
    copy ORACLE:\ORANW815\APPS\DATA\FIN_APP2.DBF BACKUPATA

    Missed the back slash.

    Queyon
    Queyon Zeng
    Share on Google+

  3. #3
    Join Date
    Jun 2002
    Posts
    5
    Hi Queyon Zeng,
    I tried the following with and without the backslash :

    alter tablespace FIN_APPS begin backup;
    HOST copy ORACLE:ORANW815\APPS\DATA\FIN_APP1.DBF BACKUPATA\
    HOST copy ORACLE:ORANW815\APPS\DATA\FIN_APP2.DBF BACKUPATA\
    alter tablespace FIN_APPS end backup;

    But what happens is that the first datafile i.e. FIN_APP1.DBF, starts copying, but before it can even finish, the HOST returns back to the script, and all the subsequent tablespaces go in 'Backup Mode', go back to 'Normal Mode' and the full script runs quickly and ends and only the first datafile (mentioned above) gets copied; and all this with COPY.NLM, but nothing seems to work with OCOPY81.NLM

    Mike.
    Share on Google+

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

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