Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Answers were Sorted based on User's Feedback
Answer / guest
ORACLE_BASE is the root directory for oracle. ORACLE_HOME
located beneath the ORACLE_BASE and is the place oracle
products reside.
Regards
Abhinav Phadnis
Is This Answer Correct ? | 22 Yes | 0 No |
Answer / shiva
$ORACLE_BASE: TOP OF ORACLE DIRECTORY
eg: u01/app/oracle
$ORACLE_HOME : WHERE THE ORACLE IS INSTALLED IN OUR SYSTEM
eg: $ORACLE_BASE/PRODUCT/RELEASED_VERSION
Is This Answer Correct ? | 5 Yes | 4 No |
How will u copy the objects of one schema to another schema in datapump & export/import?
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
how can you implement fine-grained auditing?
Which autogrowth database setting is good? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
the process of adding a cpu in sql server is called..?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you initialize log miner?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Where in the Oracle directory tree structure are audit traces placed?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA