-
show sql script of a existing object...
Hi..
There are many objects in the dba_objects, like table, trigger, index...
How can I view the createing sql script of each object by using oracle command ??
for example:
table XXX
show==> create table XXX
( id number NOT NULL,
name varchar2(10) NOT NULL);
-
9i?
use dbms_metadata
EXAMPLE....
SQL> create table t1 (empid NUMBER, ename VARCHAR2(20));
Table created.
SQL> SET LONG 9999
SQL> select dbms_metadata.get_ddl('TABLE','T1') from dual;
DBMS_METADATA.GET_DDL('TABLE','T1')
--------------------------------------------------------------------------------
CREATE TABLE "SYS"."T1"
( "EMPID" NUMBER,
"ENAME" VARCHAR2(20)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM"
I'm stmontgo and I approve of this message
-
Hi
Before 9i you can use export import utilites...first export the user with rows=N option and then import it with indexfile=my-ddl.sql..this file would contain the ddl for your user..
regards
Hrishy
-
Use TOAD s/w(exe)....may it be 9i or previous versions......
It will build the creating script 4 u.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|