Sarat 1) What are pre-checks you do before doing point in time recovery? 2) There is no previous level zero backup available, Can we take a Level 1 backup? 3) My database have 500+ datafiles, In that I lost 89 files. How you will identify which files to recover? 4) Can you explain what are internal mechanism of Transportable tablespace […]
Answer Credit:- https://www.linkedin.com/in/skantali/ https://www.linkedin.com/in/hemant-shahi-59921762/ How we can execute PLSQL without any privilege to change it What are the default user created when Oracle is installed ? Can you create password less user in Oracle ? If yes how ? How we can see the procedure /package body with out having privilege to execute it How we can create password file […]
What are base tables? When and how they will get created? Ans:-Are read-only tables(Data Dictionary Tables) that hold information about the database. Base tables are own by SYS. When and how they will get created? They get created when the database is built. https://docs.oracle.com/cd/B19306_01/server.102/b14220/datadict.htm Why to execute catproc.sql script? Ans:-Used to create and recreate database internal views/procedures/packagess. Primarily used after […]