How do I partition an Oracle 11g Table? Post: 302928054

Sponsored Content

Top Forums Programming How do I partition an Oracle 11g Table? Post 302928054 by gandolf989 on Monday 8th of December 2014 02:13:32 PM

12-08-2014

Registered User

If you are using 11g, then you want to use interval partitioning. Oracle will create a new partition every month for that months data. However, you might find that partitioning by day will work better, since you are working with audit data you might only look at the last day or last couple of days when querying the data. Having smaller level of granularity when used with partition pruning will likely lead to fewer io operator per query. Hence more efficient queries. You might also want to partition by month and sub partition by day. This will make it easier to drop a month at a time when you truncate old data, assuming that you do. You should be able to find plenty of examples for what you want on the web.

https://docs.oracle.com/cd/E18283_01...1.htm#BAJHFFBE

gandolf989

View Public Profile for gandolf989

Find all posts by gandolf989

2 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;...

2. Solaris

need help in oracle upgrade from 10g to 11g

Hi , situation has come where in i want to upgrade my database from 10g to 11g ,my code heavily depends on Pro*C , i just want to know if i upgrade my DB from 10g to 11g , will there be any changes in my pro*c compiler ..? if so then wat are the prerequisites i need to check ..? thanks ...

LEARN ABOUT HPUX

findfs

FINDFS(8)						       System Administration							 FINDFS(8)

NAME

       findfs - find a filesystem by label or UUID

SYNOPSIS

       findfs NAME=value

DESCRIPTION

       findfs  will  search the block devices in the system looking for a filesystem or partition with specified tag. The currently supported tags
       are:

       LABEL=<label>
	      Specifies filesystem label.

       UUID=<uuid>
	      Specifies filesystem UUID.

       PARTUUID=<uuid>
	      Specifies partition UUID. This partition identifier is supported for example for GUID  Partition	Table (GPT) partition tables.

       PARTLABEL=<label>
	      Specifies partition label (name). The partition labels are supported for example for GUID Partition Table  (GPT)	or  MAC  partition
	      tables.

       If the filesystem or partition is found, the device name will be printed on stdout.

       The complete overview about filesystems and partitions you can get for example by

	      lsblk --fs

	      partx --show <disk>

	      blkid

EXIT STATUS

	      0      success
	      1      label or uuid cannot be found
	      2      usage error, wrong number of arguments or unknown option

AUTHOR

       findfs was originally written by Theodore Ts'o <tytso@mit.edu> and re-written for the util-linux package by Karel Zak <kzak@redhat.com>.

ENVIRONMENT

       LIBBLKID_DEBUG=all
	      enables libblkid debug output.

SEE ALSO

       blkid(8), lsblk(8), partx(8)

AVAILABILITY

       The  findfs  command  is  part of the util-linux package and is available from Linux Kernel Archive <https://www.kernel.org/pub/linux/utils
       /util-linux/>.

util-linux							    March 2014								 FINDFS(8)