define schema='schema_name'
                        

                        create table &schema..tblname (
                        

                           col1name number constraint tblname_1_nn not null,
                        

                           col2name char(n) constraint tblname_2_nn not null,
                        

                           col3name varchar2(n) constraint tblname_3_nn not null,
                        

                           constraint tblname_0_pk
                        

                              primary key (col1name)
                        

                              using index tablespace index_tspname​
                        

                                 pctfree    5
                        

                                 initrans   1
                        

                                 maxtrans 255
                        

                                 storage (
                        

                                    initial 1k
                        

                                    minextents 1
                        

                                    maxextents unlimited
                        

                                 )
                        

                        )
                        

                        tablespace data_tspname​
                        

                           pctfree    5
                        

                           initrans   1
                        

                           maxtrans 255
                        

                           storage (
                        

                              initial 4k
                        

                              minextents 1
                        

                              maxextents unlimited
                        

                           );
                        

                        grant select, insert, update, delete
                        

                           on &schema..tblname​
                        

                           to rolename1,
                        

                              rolename2;