sql script

heloo dear friends,I need to create a sql script ,it contains 20 tables and indexes.plss give me script example how to create that script in sunsolaris.When i will execuite that script then imm all tables must be created.
plss help me

heloo dear friends,I need to create a sql script ,it contains 20 tables and indexes.plss give me script example how to create that script in sunsolaris.When i will execuite that script then imm all tables must be created.
plss help me

If you are using Oracle 9i, then it is easy. You can use DBMS_METADATA package.

Example is shown here:
http://www.dbaclick.com/cgi-bin/ib3/...t=ST;f=17;t=11


For more cool ideas check the latest Oracle DBA forums:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

:)

--clio_usa
Senior Oracle DBA

Hii friend i did not get the exact syntax from http://www.dbaclick.com,suppose i have 2 want to execuite 2 tables at a time,so can u give code for that.
thanks

OK.

Start the spooling and change the query from the link to:

SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
FROM USER_ALL_TABLES u
WHERE u.nested='NO'
AND (u.iot_type is null or u.iot_type='IOT')
AND table_name IN ('TABLE_1','TABLE_2','TABLE_3', ..............);

Stop the sooling to get the DDL in text file. If you setup LINESIZE, PAGESIZE, HEADING, etc you can get clear SQL. The run it from shell scripts in UNIX.

You could use DBA_TABLES and limit by OWNER in the where clause. It is up to your needs to change the query. The idea is still the same...

You have to put some efforts to compile all that of course. Like to show how to catch the fish, not to serve the cooked one... :)

:)


--clio_usa
Senior Oracle DBA

Check the latest Oracle DBA forums:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

for clio_usa

i just wanted to know whether dba click.com and dbasupport.com belong to same organization.

pravin,

http://www.dbaclick.com has no assosiations with http://www.dbasupport.com or any dbaxxxxx sites.

Thank you for your interest !

--clio_usa
:)

encourage members to use this dba_support_ forum for all answers , if u do a search on any topic u can get all answers.

instead of relying on other web site forums such as dba.click for all answers.

-- Pravin