data object allocation

• shiv gupta-279632

  Newbie

  Points: 5

  More actions

  November 23, 2005 at 4:14 am

  #110385

  hi,

  i struct in finding out the data object allocation to specific files present in the defaualt file group.

  Let me explain with example

  there is a filegroup having two data files with it. i.e a_file and b_file

  the configuration of file is as follows:-

  1.) a_file = it max size is ristricted some limit

  2.) b_file = it max size is unlimited.

  After the size is full in a_file , though it is ristricted data started allocating into b_file. After some time we deleted some data which is present in a_file resulting in free space available in a_file.

  Now let me know how we can switch over from b_file to a_file . (not from enterprize manager, need some what automated solution, wanna create program for this)

  With Regards

  Shiv

• November 28, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Marimuthu-129612

  Hall of Fame

  Points: 3266

  More actions

  November 30, 2005 at 8:25 am

  #606759

  Create/Recreate the indexes on the object