What are the advantages of using Oracle Managed Files?
920689
OMF simplifies the creation of databases as Oracle does all OS operations and file naming. It has several advantages including:\n\n    * Automatic cleanup of the filesystem when database objects are dropped.\n    * Standardized naming of database files.\n    * Increased portability since file specifications are not needed.\n    * Simplified creation of test systems on differing operating systems.\n    * No unused files wasting disk space.\n\n///
117633
I'm only answering this because I haven't seen anyone else.  I'm not an Oracle DBA, but I have extensive experience in SyBase.\n\n1) Look through your doc for a thing called sqlloader - this is the thing Oracle provides to do the job.  Basically, unloading a table using sqlloader takes the data in your table and writes it in a format that sqlloader can rewrite.\n\n2) If you are really good at PL/SQL, you can write you own unload/reload process (this is what I have to do to move data from one RDBMS to another, like from Oracle to Sybase).  Write a program that generates as output the SQL Insert statements needed to load your data.  In other words, it writes on Insert statement for every row that already exists.
589940
yes it is possible to install oracle on XP. it requires some some net 8 configurations
956429
The disk space it saves is negligable.\n\nHowever, it makes your files more secure than the old fat system.
937881
these links can help\n\nhttp://www.dba-oracle.com/oracle_tips_db_copy.htm\nhttp://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci979078,00.html
143941
1) Oracle has a program call SQL Loader that loads tables from external data.  You can write a module in Access to create a flat fiel from your data and put it in a form where SQL Loader understands.\n\n2) A solution that works with almost any RDBMS is to write a module in Access to create SQL Insert statement for each record in your Access table, and write them to a file.  Then, using the RDBMS's batch execution engine (SQL PLus for Oracle, OSQL for SQL Server, MySQL command prompt, etc, ISQL for Sybase, etc), simply create yout table and run those insert statements.\n\nAn example of 2) would be ...\n\nFunction doIt()\n\nDim rs As Recordset\n\nSet rs = CurrentDb.OpenRecordset("Select f1, f2 from t1;")\nOpen "c:&#92;statements.sql" For Output As #1\nWhile Not rs.EOF\n    Print #1, "Insert into T1 (F1, F2) values ('" & rs("f1") & "', '" & rs("f2") & ")';"\n    rs.MoveNext\nWend\nClose\nrs.Close\n\nEnd Function
957379
check this dude...\n\nhttp://download.oracle.com/oowsf2005/666.pdf
868100
Sounds like you want to use a database like Filemaker. With a database you can create custom reports that could be used as tests.
641948
Hmm I've never used an Oracle Database with Access yet. However, hope this link help: http://www.orafaq.com/faqodbc.htm
937744
If what you are asking is what you can use to store and manage data (don't know about the 'buy' part) I can take a stab at it. \n\nI am a software engineer that has been writing database applications for 13 years. What I have used are:\nMicrosoft Access (http://office.microsoft.com/en-us/access/default.aspx)\nMySQL (an Open Source, free database) (http://www.mysql.com/)\nMicrosoft SQL Server (http://www.microsoft.com/sql/default.mspx) and \nOracle (http://www.oracle.com/index.html).  \n\nThese are pretty much the viable solutions depending on the application. MS Access is more of a poor-mans solution but certainly capable of handling 100's of thousands of rows of data, MySQL is a bit more complex but has evolved and even has a User Interface to manage the database now and fairly capable in terms of it's data capacity. SQL Server/Oracle are the full-blown Database Management Systems (DBMS) that cost the big bucks to license but are what large enterprises/web sites use to hold all their data.\n\nHope this helps.
1122852
Try here:\n\nhttp://www.oraclesource.net/index.php
606482
Normally private software have their own way to store data through proprietary format files.\n\nAn Microsoft Access or Microsoft SQL Server can do the same thing (and often better) than those proprietary format but you need to buy them (and they are expensive).\n\nIn fact, Access and SQL Server is normally used by business to keep their information about their customer. I won't tell you the difference between all those databases but if you really need something to work with, I suggest you SQL Server 2005 Express which is totally free. ( http://go.microsoft.com/fwlink/?LinkId=64064 )
887001
Oracle - and Microsoft's SQL Server - are good for large scale (think web based or Wide-Area-Network) database applications.  Access is good for SMALL scale - single computer, or very small, local area network database applications.  Also, an Access database can't have very many users logged in at the same time.  SQL Server and Oracle can have lots of users logged in at once.
657055
It is a database software.
439349
The only problem I can think of is that you likely wont be able to pick up any updates as they put out. But, with Oracle, that can be a BIG problem, think security.
628067
The spreadsheet tends to be a standalone solution where your data and your presentation are in the same file.  The advantage is that it is simple and easy to manipulate and easy to pass around.  The disadvantage is that it has few controls, data can be modified without an audit trail, it is difficult for more then one person to modify it at any one time and data can spill out of the initial sheets into new columns or sheets through updates.  This makes it difficult to use the data in other products.
474828
It depends on the level of your knowledge. Use what you know better. Surely, UNIX is much better because at least its flexibility.