Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between an Oracle Schema and an
Oracle Instance?

Answer Posted / udayah shankar dokku

oracle schema: generally it is static,having tablr
name,column name & associated datatypes
oracle instance : generelly it is dynamic,at ay instance of
time the collection of all records is called oracle instance

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the oracle implicit cursor?

1001


How do I use unicode codesets with the weblogic jdriver for oracle driver?

1015


How to create lov dynamically at runtime & attach to text field?

1098


What is translate in oracle?

1051


How to import one table back from a dump file?

972


Explain drop constraint oracle?

991


How to create a single index for multiple columns?

980


When system tablespace is created?

972


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2045


How to grant create session privilege to a user in oracle?

948


How to create a new oracle data file?

971


How to resolve name conflicts between variables and columns?

982


What is an oracle function?

1074


What is recovery manager(rman) backup in Oracle?

1127


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1996