This content has been marked as final. Show 3 replies
RajeshKanna wrote:You can get the list of tables in a schema using the dictionary table [url http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2105.htm#i1592091]ALL_TABLES. And you can use the oracle supplied package [url http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_metada.htm#ARPLS026]DBMS_METADATA to get the create table script
how can i read the tablescripts in HR schema.
can any one help me the which package i am using to retrive the entire scripts??
select table_name, dbms_metadata.get_ddl('TABLE', table_name, user) table_script from all_tables where owner = 'HR'