Home » RDBMS Server » Backup & Recovery » Where is database and tables saved
Where is database and tables saved [message #111417] Wed, 16 March 2005 05:15 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Restore one tablespace!
Next Topic: IMP-00058
Goto Forum:
  


Current Time: Fri Mar 29 00:11:20 CDT 2024