Fake Blogger

Oracle 10g Datapump for Export (expdp):
CREATE DIRECTORY export_dumps AS ‘c:\a’;
GRANT read, write ON DIRECTORY export_dumps TO gennick;

PAR-FILE:
DUMPFILE=gnis%U.dmp
DIRECTORY=export_dumps
LOGFILE=gnis_export.log
JOB_NAME=gnis_export
select * from all_directories;
DUMPFILE specifies the file to which I want to write exported data. The %U syntax gives me an incrementing counter, resulting in the filenames gnis01.dmp, gnis02.dmp, and so forth. DIRECTORY specifies my target directory.Note that if […]

select comp_id, comp_name, version,status from dba_registry;

opatch lsinventory -detail