Probelms createing table as sysdba...
834783Jan 13 2012 — edited Jan 13 2012On Oracle 9.2.06 on HP-UX, I'm running sqlplus "/ as sysdba" and trying to create thi table:
CREATE TABLE CUSTOM.AUDIT_TRANS_DUMP_201110
(dstrct_code varchar(4),
process_date varchar(8),
transaction_no varchar(11),
userno varchar(4),
rec900_type varchar(1),
rec900_type_desc varchar(50),
tran_type varchar(3),
tran_desc varchar(50),
tran_group_key varchar(28),
line_no varchar(4),
account_code varchar(28),
cost_center varchar(10),
batch_no varchar(10),
creation_date date,
creation_time varchar(6),
full_period varchar(6),
debit_amt number,
credit_amt number,
j_description varchar(40),
currency varchar(4),
creation_user varchar(10),
created_by varchar(80),
appr_user varchar(10),
appr_by varchar(80))
TABLESPACE USERS
NOLOGGING
NOPARALLEL
NOCACHE;
When I log on as / sysdba - aren't I logged on as SYS which should be able to create a table?
I'm getting this error.