Partition In Custom Table Space Using Partition_util (Doc ID 2770137.1)

Last updated on AUGUST 28, 2023

Applies to:

Goal

Do we have the options to create partition in other table space apart from default table space by using the partition_utility.
By default if we execute partition util it will create partition in default table space. But we want to specify table space during partition creation.
Please let us if this is possible.

The below are the options available with the partition_utility Utility currently.
$ partition_utils -help
Usage: partition_utils
  -o <add, remove, enable, update, purge, maxpoid, restart>
  -t <realtime, delayed>
  -s
  -e
  -q
  -u <month, week, day>
  -c
  [-w]
  [-f]
  
  [-p]
  [-b]
  
  -h

Use partition_utils -o option -h to get help for each option.
Like partition_utils -o add -h to get syntax of add option.
[partition_utils]$
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.