saving new database

[softdrink]

Wher I create new table and enter all the info I want, what it the best way to save it so I can take it with me, and open it, access it, from another machine.

thanks,
softdrink

 

[sem]

You may use Oracle Lite to replicate data.

 

[softdrink]

keep in mind that I'm learning, I will explain a bit more. I have a database created by someone else. All I did was open the DB and did : start database_name and the DB was there for me to use. How can I do that?

softdrink

 

[sem]

Do you need to access it from another machine connected by LAN or get some snapshot of the original database? You may connect to source database via sql*net. Though if you need some "snapshot", you have to learn about replication or at least about export/import.

 

[softdrink]

Ok, I'm in my SQLPlus and I'm creating a table. I set everything up and enter the data that I want. When all is good and properly set up, I want to save it, as backup, so in case I need to use it on my other computer or my computer goes dead, I can take that file and open it from SQLPlus.

I hope that's clear

thanks sem

softdrink

 

[Turkbear]

Hi, to do that you need to have Oracle installed on the other machine, of course.
You can then do a TABLE ( or OWNER) mode export from one system and import it into your other instance of Oracle.
The table alone, without Oracle, is not useful.
You can save the data in the table in some form of delimited file(s) and use it in other tools but, as a database table, you need to use Oracle to work with it..

 

[softdrink]

thanks, so basically the database stays in the Oracle, in m computer, go it.

what about doing a backup, in case computer crashes, how would I do that?

softdrink

 

[Turkbear]

It depends - ( my,isn't that helpful )

The simplest method is to use the EXPORT command and copy the resulting DMP file someplace safe ( depending on size, to a CD or a tape maybe ) and store it away from your normal workarea ( Fires and floods do happen)

Do this on a regular basis ( depending on how much and how often your data changes) and you should be OK - If all else fails, you could reinstall Oracle and IMPORT your saved data saving at least the stuff entered up to the export date..

There are many other methods, so read the backup and recovery Docs..

 

[softdrink]

thanks a lot, much appreciated, will do just that.

softdrink