Sponsored Content
Top Forums Programming How do I partition an Oracle 11g Table? Post 302928048 by bbbngowc on Monday 8th of December 2014 01:29:05 PM
Old 12-08-2014
How do I partition an Oracle 11g Table?

Hello,

I have a database called "audit_database" and I want to create two tables.

Table 1 = Table 1
Table 2 = Audit

I want to partition the Audit table into partitions grouped by month. I'm not familiar with table partitioning but doing some reading online shows that it can be done but how would I do this?

Code:
create table audit (month number(12),
  partition by range (month)
  partition 1 = january ...?

 

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 Replies)
Discussion started by: NetBear
2 Replies

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 ... (2 Replies)
Discussion started by: senkerth
2 Replies
KPARTX(8)                                                  Linux Administrator's Manual                                                  KPARTX(8)

NAME
kpartx - Create device maps from partition tables SYNOPSIS
kpartx [-a | -d | -l] [-v] wholedisk DESCRIPTION
This tool, derived from util-linux' partx, reads partition tables on specified device and create device maps over partitions segments detected. It is called from hotplug upon device maps creation and deletion. OPTIONS
-a Add partition mappings -r Readonly partition mappings -r Read-only partition mappings -d Delete partition mappings -u Update partition mappings -l List partition mappings that would be added -a -p set device name-partition number delimiter -f force creation of mappings; overrides 'no_partitions' feature -g force GUID partition table (GPT) -v Operate verbosely -s Sync mode. Don't return until the partitions are created EXAMPLE
To mount all the partitions in a raw disk image: kpartx -av disk.img This will output lines such as: loop3p1 : 0 20964762 /dev/loop3 63 The loop3p1 is the name of a device file under /dev/mapper which you can use to access the partition, for example to fsck it: fsck /dev/mapper/loop3p1 When you're done, you need to remove the devices: kpartx -d disk.img SEE ALSO
multipath(8) multipathd(8) hotplug(8) AUTHORS
This man page was assembled By Patrick Caulfield for the Debian project. From documentation provided by the multipath author Christophe Varoqui, <christophe.varoqui@opensvc.com> and others. July 2006 KPARTX(8)
All times are GMT -4. The time now is 11:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy