view does not exist physically.
what it means

view is a logical entry.A regular view does not store any data,only the definition,and the underlying query is run every time the view is accessed.

– how u see how many database are on ur linux box & how many start or stop
--which files are used to configyration when we install oracle on linux
4 – what is oratab & oraenv how u use

hey,
the . oraenv is used to set the path n name of your database in linux. if one escapes specifying the oraenv then by default the test database is opened n the default path is oracle home. thereafter when u specify startup in the sql prompt than instead of your database to be mounted or opened or nomounted the test database will be worked upon.

any queries plz revert.
ll try best to solve the queries.

view doesnt exist physically means it has logical existence in the database.it doesnt occupy any space in the database memory . no new table is created when a view is created.it is used just to perform sql query on the logical data and return the output