Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    1

    Unanswered: Online data of Oracle in a Pen Drive (data stick)

    I am using oracle 9i and work on the server. I would like to have a solution where one database user's data can be kept in a pen drive (Data Stick or Memory Stick) so that this pen drive can be attached and and after working on this I can detach and keep with me. This is to ensure that all the data in that perticular user is in the detachable drive.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    Interesting question. I've never tried it, but did you try giving the user his/her own tablespace with a datafile on the pen drive, and then take the tablespace offline when the user needs to remove the pen drive? They probably need DBA role to do it. If you have multiple users sharing the same table, maybe you could (in theory) create a partition per user and take individual partitions offline, but then ever user would need the DBA role. Also consider that when the users want to start working again, the SYSDBA will probably have to perform database recovery operations on the pen-drive files to let Oracle update the file headers with the current scn.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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