Hai buddy,

I am having a 9ilite database dump as .odb file. I need to take all the objects from that 9ilite database to a existing 9i database. tell me how to do it.

If you need any further information regarding this i will provide


with regards,
rasmarter.

"I need to take all the objects from that 9ilite database to a existing 9i database."

export import: http://www.dba-oracle.com/concepts/imports_exports.htm

or CTAS: http://www.dba-oracle.com/t_create_table_select_ctas.htm

I don't believe you can do that, the two DBs are not compatible that way. You will have to do it manually.

You will have to do it by extracting the DDL.
http://www.dba-oracle.com/art_builder_get_schema_syntax.htm

The OLLOAD utility http://download.oracle.com/docs/html/A97672_01/wn32util.htm will extract data into files.

Then create your objects in the target db using the DDL

Then use either SQL Loader or straight SQL (DDL and DML) to create the objects and populate in your target DB.

hai,

thanks buddy. thank you for your timely and correct reply. once again thank you.

For me using olload i am able fetch records to a file.

But i need the ddl of the objects present in that dump. beacause i am having only dump file as database that is database as .odb with that i cannot use "dbms_metadata.get_ddl" to fetch the ddl script. so please help me out how to fetch the ddl of the objects present in the dump as .obp file( which is connected only by query tool in my knowledge) that to for only querying the records by using odbc drivers.

so please help me out how to get ddl of objects present in a 9i lite dump with extension as .odb.

with regards
rasmarter.

have a nice day.