1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
reach.santanubanerjee

Create table within a schema & tablespaces 2014-02-10

Create table within a schema & tablespaces

  1. reach.santanubanerjee
    To see tablespace for a selected user
    desc dba_users
    select username,default_tablespace from dba_users;


    create table KDC_DSS.RG_ISI_SMS_MOU_DAILY
    (
    CUSTOMER_NAME VARCHAR2(255),
    FRANCHISE_ID VARCHAR2(15),
    RATING_COMPONENT VARCHAR2(8),
    BILLING_OPERATOR_ID VARCHAR2(6),
    BILLING_PERIOD NUMBER(10),
    COMPONENT_DIRECTION VARCHAR2(2) ,
    BILLED_PRODUCT_ID VARCHAR2(14),
    TIER VARCHAR2(8),
    TIME_PREMIUM VARCHAR2(3),
    CURRENCY VARCHAR2(3),
    STATEMENT_DIRECTION VARCHAR2(1),
    CALL_START_DT DATE,
    CALL_COUNT NUMBER(10),
    MOU NUMBER(10,5),
    ACTUAL_MIN NUMBER(10,5),
    BILLED_AMOUNT NUMBER(10,5),
    RATE NUMBER(10,5),
    RECORD_DT DATE
    )
    TABLESPACE RGCOM;