| table scripts [message #72258] |
Fri, 25 April 2003 23:29  |
annu
Messages: 34
Registered: February 2002
|
Member |
|
|
hi,
Is there any utility, software or way to obtain tables structure in a script file with constraints. Give me an idea how can i make table scripts in a scripts file with one command or with some kind of utility. while i m using oracle 9i database ..
|
|
|
|
|
|
|
|
| Re: table scripts [message #72275 is a reply to message #72258] |
Wed, 30 April 2003 06:02  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
if you cannot afford those tools mentioned by others, with 9i you also make use of this builtin
dbadmin@jumpstart1_mutation > create table sample
2 (id number,
3 name varchar2(10));
Table created.
dbadmin@jumpstart1_mutation > select dbms_metadata.get_ddl('TABLE','SAMPLE') from dual;
DBMS_METADATA.GET_DDL('TABLE','SAMPLE')
--------------------------------------------------------------------------------
CREATE TABLE "DBADMIN"."SAMPLE"
( "ID" NUMBER,
"NAME" VARCHAR2(10)
)
dbadmin@jumpstart1_mutation >
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
