Delphix Products

Expand all | Collapse all

How to take a data dump from a particular table which is a Oracle VDB. Does any utility available

Jump to Best Answer
  • 1.  How to take a data dump from a particular table which is a Oracle VDB. Does any utility available

    Posted 07-11-2016 11:25:00 AM
    How to take a data dump from a particular table which is a Oracle VDB. Does any utility available within Delphix. I am creating a table in the VDB. I wanted to take the dump of this table before doing Data Refresh/Data Rewind. Once the Data Refresh/Data Rewind is over. I wanted to bring back the data dump to the VDB. Please let me know your suggestions.

    #Tip
    #DemoEnvironment


  • 2.  RE: How to take a data dump from a particular table which is a Oracle VDB. Does any utility available
    Best Answer

    Posted 07-11-2016 11:49:00 AM
    Hello,

    An Oracle VDB is just an Oracle database. You could use your favorite technique that you normally use for Oracle such as its export utility:

    https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm

    Thanks,
      Neal


  • 3.  RE: How to take a data dump from a particular table which is a Oracle VDB. Does any utility available

    Posted 07-11-2016 01:17:00 PM
    Ramesh, like Neal said, you can just use something like expdp/impdb (oracle datapump). Furthermore, you could configure these as pre-refresh and post-refresh hooks so that the table is exported and imported automatically as part of your refresh operation in Delphix.