Database Administration (MOSC)

MOSC Banner

Strange Errors when partition table in 9.2.0.4

edited Jun 18, 2012 2:11AM in Database Administration (MOSC) 5 commentsAnswered
Hi all,
  I tried partition table with oracle 9.2.0.4 64 bit on AIX. But I'm not lucky ! I hope some receive some helps.

  I have a table with about 10 million records. With this table, already exist :

    + two triggers,
    + five indexes,
    + two constraints.
    + some synonyms.

  My original table is look like:

  table_A(
    a_id number not null,
    a_value number default 1,
    a_date date defaut sysdate,
    ......
  );

  I did steps follows:

  1. I created table with same structure:

              create table_A_ref(
    a_id number not null,
    a_value number default 1,
    a_date date defaut sysdate,
    ......
  )
Partition by range(a_date)
(
  partition P08152008 values less than (to_date('15/10/2009','DD/MM/YYYY')),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center