QUOTE (ConwayAD @ Apr 10 2008, 06:51 PM)
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.
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.
have a nice day.