Where is database and tables saved [message #111417] |
Wed, 16 March 2005 05:15 |
Vrinda V
Messages: 17 Registered: October 2004
|
Junior Member |
|
|
Please enlighten me with information
"In which file is the database and tables and procedures etc stored . "
I logged on as system/manager.
I want to copy the contents to another computer and work on from there. I am using personal Oracle 8i
Vrinda
|
|
|
Re: Where is database and tables saved [message #111447 is a reply to message #111417] |
Wed, 16 March 2005 08:15 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>"In which file is the database and tables and procedures etc stored
anything stored in database is stored in a datafile physically.
But you cannot directly read and fetch those information out of oracle datafiles.
the same information is logically available in forms of tables( data) an little structures of code is stored as stored procedure/triggers/views are available in certain metadata( data about data) liek user_source and user_tables.
if you are looking into transfering the contents of one database to another database, export/import is the easiest way.
Please search oracle docs/this site/google for export/import in oracle.
|
|
|