Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> .odb dump of 9ilite database
rajsmarter
post Apr 10 2008, 03:11 AM
Post #1


Advanced Member
***

Group: Members
Posts: 71
Joined: 27-February 08
Member No.: 18,113



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.


--------------------
Anbudan ra.
Nandri.
Go to the top of the page
 
+Quote Post
HAL9000
post Apr 10 2008, 08:02 AM
Post #2


Advanced Member
***

Group: Members
Posts: 880
Joined: 25-September 07
Member No.: 12,336



"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
Go to the top of the page
 
+Quote Post
ConwayAD
post Apr 10 2008, 08:20 AM
Post #3


Advanced Member
***

Group: Admin
Posts: 58
Joined: 4-December 06
Member No.: 5,987



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.
Go to the top of the page
 
+Quote Post
rajsmarter
post Apr 10 2008, 12:24 PM
Post #4


Advanced Member
***

Group: Members
Posts: 71
Joined: 27-February 08
Member No.: 18,113



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.



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.


--------------------
Anbudan ra.
Nandri.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th October 2014 - 02:39 PM