Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Probelms createing table as sysdba...

834783Jan 13 2012 — edited Jan 13 2012
On 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2012
Added on Jan 13 2012
5 comments
674 views