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
FDISK(8)						    BSD System Manager's Manual 						  FDISK(8)

NAME
acorn-fdisk -- partition editor for Acorn/RISC OS machines SYNOPSIS
acorn-fdisk -h | --help | -v | --version acorn-fdisk [-t scheme | --type scheme] -l | --list [device ...] acorn-fdisk [-t scheme | --type scheme] -s | --size partition acorn-fdisk [-t scheme | --type scheme] [device] DESCRIPTION
The acorn-fdisk utility allows one to display or interactively edit partition tables for Acorn/RISC OS machines in various formats. Using the PC/BIOS format, standard IBM PC (i386) partition tables can also be accessed. When no optional device is given, it defaults to /dev/hda or /dev/sda. The options are as follows: -h | --help Display a short usage and exit immediately. -l | --list Display the partition table(s) of all devices. -s | --size Display the size of partition. -t | --type Select the partitioning scheme to use. Valid schemes are: EESOX Eesox SCSI on the Acorn machines. ICSIDEFS ICS IDE. Filecore/Linux Linux on Filecore. This uses the non-ADFS descriptor to point to the start of the disc to be partitioned. The first two sectors contain a partition table to identify the Linux partitions contained within. PC/BIOS PC/BIOS partitioning scheme. This consists of a partition table in the first sector of the disk which contains both CHS and LBA values for the partitions. There can be up to four entries in the primary partition table. One of these can be an extended partition containing up to four extra partitions. PowerTec PowerTec SCSI on the Acorn machines. Filecore/RISCiX RiscIX on Filecore. -v | --version Display the version of acorn-fdisk and exit immediately. If neither -l | --list or -s | --size are given, the partition table of the given device will be edited interactively. EXAMPLES
Display the default device's partition table on a PC: acorn-fdisk --type PC/BIOS -l Display the PC partition table of /dev/sda: acorn-fdisk --type PC/BIOS --list /dev/sda Display the size in blocks of the partition /dev/sda1: acorn-fdisk --type PC/BIOS --size /dev/sda1 Edit the MBR partition table interactively: acorn-fdisk --type PC/BIOS Display the partition table of an MBR backed up to a file: acorn-fdisk -t PC/BIOS -l mbrdump.bin Display the size of the first partition on a device where the MBR would be restored from the backup file mbrdump.bin: acorn-fdisk -t PC/BIOS -s mbrdump.bin1 AUTHORS
arm-fdisk was written by Russell King <rmk@arm.uk.linux.org> based on util-linux fdisk, which was written at least partially by A. V. Le Blanc <LeBlanc@mcc.ac.uk>. This manual page was written for the Debian system by Thorsten Glaser <tg@debian.org> but may be used by others. BSD
October 2, 2010 BSD
All times are GMT -4. The time now is 08:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy