Advertisement
Guest User

Untitled

a guest
Apr 26th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.82 KB | None | 0 0
  1. CREATE TABLE A4_CAMPAIGN
  2.   (
  3.     campaign_id            INTEGER NOT NULL ,
  4.     campaign_name          VARCHAR2 (50) NOT NULL ,
  5.     campaign_kind          VARCHAR2 (25) NOT NULL ,
  6.     campaign_category      VARCHAR2 (25) NOT NULL ,
  7.     campaign_payment_type  VARCHAR2 (15) NOT NULL ,
  8.     campaign_creation_name VARCHAR2 (25) ,
  9.     campaign_rating        VARCHAR2 (25) ,
  10.     campaign_create_date   DATE NOT NULL ,
  11.     campaign_launch_date   DATE ,
  12.     campaign_inactive_date DATE ,
  13.     campaign_summary CLOB ,
  14.     ind_email VARCHAR2 (25) NOT NULL
  15.   )
  16.   PCTFREE 20
  17.   STORAGE (INITIAL 1M NEXT 128K MAXEXTENTS 10)
  18.   TABLESPACE AKSARBEN_128K;
  19.  
  20. [3:44]
  21. but keep getting :
  22. 01950. 00000 -  "no privileges on tablespace '%s'"
  23. *Cause:    USER does NOT have privileges TO allocate an extent IN the
  24.            specified tablespace.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement