Database Administration (MOSC)

MOSC Banner

ORA-14030: non-existent partitioning column in CREATE TABLE statement

Hello Team,

I encountered the above error when creating a new partition table. The table creation script is below:

CREATE TABLE trsf_acc_to_wallet_ht

  (trx_id             VARCHAR2(15 CHAR),

  internal_reference_number   CHAR(12 BYTE) NOT NULL,

  sequence_number        NUMBER(3,0) NOT NULL,

  bank_code           CHAR(5 BYTE) NOT NULL,

  branch_code          VARCHAR2(5 BYTE),

  wallet_number         VARCHAR2(22 BYTE) NOT NULL,

  account_number         VARCHAR2(24 BYTE),

  dest_account_number      VARCHAR2(24 BYTE),

  dest_bank_code         CHAR(5 BYTE),

  src_account_number       VARCHAR2(24 BYTE),

  account_currency        CHAR(3 BYTE),

  dest_wallet_number       VARCHAR2(22 BYTE),

  line_number          VARCHAR2(22 BYTE),

  provider            VARCHAR2(10 BYTE),

  expiry_date          DATE,

  processing_code        CHAR(2 BYTE),

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