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),