List of all the Oracle application database schemes

List of all the application database schemes


SELECT  DISTINCT USERNAME , CREATED

FROM DBA_USERS;

Comments

Post a Comment

Popular posts from this blog

How To Export Full Database Using Expdp Utility

Full export using expdp export utility in Data Pump. Data pump in Oracle database is a server-based technology which enables very high-speed movement of data and metadata from one database to another. Component of Data pump in Oracle Database Data pump is made up of 3 components The Command-line clients, expdp and impdp The DBMS_DATAPUMP PL/SQL package ( a.k.a. Data Pump API ) The DBMS_METADATAPL/SQL package ( a.k.a. metadata API ) How Data pump works (Working of Data pump) The command-line client  expdp  and  impdp  use the procedures provided in the  DBMS_DATAPUMP  PL/SQL package to execute export and import commands using the parameters entered at the command line. Furthermore, these parameters enable the exporting and importing of data and metadata for a complete database or for subsets of a database.  Similarly, when metadata is moved, Data pump uses functionality provided by the  DBMS_METADATA  PL/SQL packa...
Read more