To get the table structure without use of toad

SQL> SET LONG 99999
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE',

'FORMS') FROM DUAL;

SQL> SELECT DBMS_METADATA.GET_DDL('TABLE',

'FORMS') FROM DUAL;

DBMS_METADATA.GET_DDL('TABLE','FORMS')
--------------------------------------------------------------------------------

CREATE TABLE "SCOTT"."FORMS"
( "ID" NUMBER NOT NULL ENABLE,
"SAR" VARCHAR2(32) NOT NULL ENABLE,
"CREATED_DATE" TIMESTAMP (3) NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM"



SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','FORMS_PART') from dual;

DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------

CREATE TABLE "SCOTT"."FORMS_PART"
( "ID" NUMBER NOT NULL ENABLE,
"SAR" VARCHAR2(32) NOT NULL ENABLE,
"CREATED_DATE" TIMESTAMP (3) NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
TABLESPACE "WEALTHMAKER"
PARTITION BY RANGE ("CREATED_DATE")
(PARTITION "FA_PART1" VALUES LESS THAN (TIMESTAMP'2006-01-01 00:00:00')

DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART2" VALUES LESS THAN (TIMESTAMP'2006-06-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART3" VALUES LESS THAN (TIMESTAMP'2006-09-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART4" VALUES LESS THAN (TIMESTAMP'2006-12-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART5" VALUES LESS THAN (TIMESTAMP'2007-03-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART6" VALUES LESS THAN (TIMESTAMP'2007-06-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART7" VALUES LESS THAN (TIMESTAMP'2007-09-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART8" VALUES LESS THAN (TIMESTAMP'2007-12-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART9" VALUES LESS THAN (TIMESTAMP'2008-03-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,

DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------
PARTITION "FA_PART10" VALUES LESS THAN (TIMESTAMP'2008-06-01 00:00:00')
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS ,
PARTITION "FA_PART11" VALUES LESS THAN (MAXVALUE)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" NOCOMPRESS )


DBMS_METADATA.GET_DDL('TABLE','FORMS_PART')
--------------------------------------------------------------------------------


SQL>