Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: Set Tablespace Containers Syntax - from DMS to SMS

    I'm trying to restore my production instance/db, PRD01, which uses DMS tablespaces to my test instance/db, TST01 such that TST01 will use SMS tablespaces (I don't want to have to manage TST01 that intensively).

    Firstly, is it even possible to do this?

    Secondly, if yes, my steps are:
    1. restore db PRD01 from /prd/i01 taken at <datetimestamp>
    to /tst/i01 into TST01
    redirect without rolling forward
    This works ok.
    2. set tablespace containers for 3 using userspace1
    Here, I'm trying to redirect tablespace-id 3 to a system managed space, "userspace1".
    3. restore db PRD01 continue

    But i can't get the syntax correct for step 2.

    Can anyone help please.

    Cheers,
    Linda

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Set Tablespace Containers Syntax - from DMS to SMS

    Try giving the full path , eg , C:\userspace1

    If you are getting errors, please make it a point to post them .... This will ensure you get the right suggestions ...

    Cheers

    Sathyaram

    Originally posted by LindaHarvey
    I'm trying to restore my production instance/db, PRD01, which uses DMS tablespaces to my test instance/db, TST01 such that TST01 will use SMS tablespaces (I don't want to have to manage TST01 that intensively).

    Firstly, is it even possible to do this?

    Secondly, if yes, my steps are:
    1. restore db PRD01 from /prd/i01 taken at <datetimestamp>
    to /tst/i01 into TST01
    redirect without rolling forward
    This works ok.
    2. set tablespace containers for 3 using userspace1
    Here, I'm trying to redirect tablespace-id 3 to a system managed space, "userspace1".
    3. restore db PRD01 continue

    But i can't get the syntax correct for step 2.

    Can anyone help please.

    Cheers,
    Linda
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    I do not think that you can convert DMS to SMS or the other way round with a redirected restore.

    The syntax for the command for sms is
    set tablespace containers for <tablespace-id> using
    (path '/apps/data/data01',
    path '/apps/data/data02');

    For DMS you can use either file or raw (and I think you can convert from device to raw and the other way)
    set tablespace containers for <tablespace-id> using
    (file '/apps/data/data01',
    file '/apps/data/data02');

    OR
    replace file with the keyword device.

    Hope this helps. Please update the post with your findings.

Posting Permissions

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