login to oracle then type below commands to get dbschema of table in oracle.
sql>set pagesize 0
sql>set linesize 32265
sql>set trimspool on
sql>set feedback off
sql>spool $outfile ($outfile is the outputfile where schema should be saved)
sql>select dbms_metadata.get_ddl('TABLE','tablename','dbname') from dual;
sql>spool off
sql>set pagesize 0
sql>set linesize 32265
sql>set trimspool on
sql>set feedback off
sql>spool $outfile ($outfile is the outputfile where schema should be saved)
sql>select dbms_metadata.get_ddl('TABLE','tablename','dbname') from dual;
sql>spool off
No comments:
Post a Comment