Oracle Database Discussions

Hi,

I have to work on a terminal machine for a client where the TOAD is not installed. For my regular DBA activities I need to take the DDL many times.
I am very much used to the style of DDL scripts which TOAD 9.6.x.x gives for any object in a schema.

Can someone suggest how I can I get exactly TOAD-like scripts (which provide not just the create statements)

For e.g.

*1.From sqlplus when I do*
select dbms_metadata.get_ddl('TABLE','APE1_ACCUMULATORS') from dual;

I get only the below

CREATE TABLE XLTDBO92.APE1_ACCUMULATORS
(
CYCLE_CODE NUMBER(4) CONSTRAINT APE1ACCU_CYCLE_CODE_NN NOT NULL,
CYCLE_INSTANCE NUMBER(2) CONSTRAINT APE1ACCU_CYCLE_INSTANCE_NN NOT NULL,
CUSTOMER_SEGMENT NUMBER(4) CONSTRAINT APE1ACCU_CUSTOMER_SEGMENT_NN NOT NULL,
CUSTOMER_ID NUMBER(9) CONSTRAINT APE1ACCU_CUSTOMER_ID_NN NOT NULL,
ACCUM_TYPE_ID NUMBER(9) CONSTRAINT APE1ACCU_ACCUM_TYPE_ID_NN NOT NULL,
OWNER_ID
)

*2.But from TOAD 9.6.x.x when i click on "create scripts" I will get*

DROP TABLE XLTDBO92.APE1_ACCUMULATORS CASCADE CONSTRAINTS;
CREATE TABLE XLTDBO92.APE1_ACCUMULATORS
(
CYCLE_CODE NUMBER(4) CONSTRAINT APE1ACCU_CYCLE_CODE_NN NOT NULL,
CYCLE_INSTANCE NUMBER(2) CONSTRAINT APE1ACCU_CYCLE_INSTANCE_NN NOT NULL,
CUSTOMER_SEGMENT NUMBER(4) CONSTRAINT APE1ACCU_CUSTOMER_SEGMENT_NN NOT NULL,
CUSTOMER_ID NUMBER(9) CONSTRAINT APE1ACCU_CUSTOMER_ID_NN NOT NULL,
ACCUM_TYPE_ID NUMBER(9) CONSTRAINT APE1ACCU_ACCUM_TYPE_ID_NN NOT NULL,
OWNER_ID
)

DROP SYNONYM XLTDB92.APE1_ACCUMULATORS;

CREATE SYNONYM XLTDB92.APE1_ACCUMULATORS FOR XLTDBO92.APE1_ACCUMULATORS;


GRANT DELETE, INSERT, SELECT, UPDATE ON XLTDBO92.APE1_ACCUMULATORS TO XLTDBO92_ALL;


So my question is:
How to such scripts from sqlplus as well ,irrespective of the type of the object?_


Regds,
Kunwar

Edited by: Kunwar on Nov 5, 2010 2:27 AM