0
How to Create Oracle directory object pointing to directory on different server?
Wiki User
∙ 15y ago
Use NFS/CIFS/similar protocol to mount remote directory appearing as local. Then this directory appears as local to the database. This means you don't need to do anything special on the DB side. Just create the directory object as usual, the operating system is responsible for actually moving files back and forth. If you use NFS, it's best to use "hard" option to prevent strange database behaviour when remote machine becomes unresponsible.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
How can we create directories in oracle database?
A directory for Oracle is created on the Unix OS. There is a "OFA" which is Oracle's standard directory structure. One of the reasons for adhering to this OFA is ease of administration. All Oracle databases are set up the same--therefore, a new DBA knows where to look for certain files in specific places. The Unix System Administration creates an Oracle DBA account. That account is allowed to create directories under an Oracle/database designated section only.
How do you copy all the files from etc directory to oracle in unix?
You will need to be more clear about the target - is 'oracle' a directory?
What is oracle software structures?
when we install d oracle software, on oracle directory structure is created to store the executables , shared libraries , configuration files , trace files , and so on both server and client software is stored in the same directory. Oracle is installed on the server using on operating system account created specially for the task oracle has a directory structure.
Why must create database in oracle?
gfhgfhgfhjgfjghk
What is the difference between oracle and oracle?
Oracle is one of the popular database and DBA (DataBase Administrator) is the person who maintain the database (install oracle software, create,setup,maintain database)
How can one create tables in Oracle?
If one is wanting to create a table in Oracle one must use the "Create Table" statement. These tables are partially defined by the columns contained and the information in the column. One must first decide the proper column type and then these data types are used in the Create Table statement. One must be somewhat familiar with Oracle in order to create these tables and additional information can be found on the DBA-Oracle website.
How do you load the data into oracle database to another database?
There are several different ways. If you are going between one Oracle database and another Oracle database you can create a database link. Another method would be an Oracle export to flat file and then a import to another database. This all depends on the type of database you are trying to load the data into.
Is the relational database an example of oracle database?
A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.
How do you create an Excel to Oracle converter?
From MS Excel, there is nothing you can create. You can save an Excel file in various formats, that might make it easier to import the data into Oracle.
What is the difference between oracle 88i9i11i10g?
They are just different versions of Oracle.
What are the components of oracle database?
DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.
What is the syntax that can be use to get a text file from a directory using oracle 9i?
The UTL_FILE package provides that support in Oracle 9i. Oracle 11g supports a new feature known as Oracle External Tables (OET), which has many advantages over UTL_FILE, though OET can't replace all the functionality in UTL_FILE (yet).
