$ expdp directory=TMP logfile=full.log dumpfile=full.dmp full=yIn alert log file:
Mon Nov 30 01:14:22 2009
ALTER SYSTEM SET service_names='service2','service1','SYS$SYS.KUPC$C_1_20091130011411.ORCL' SCOPE=MEMORY SID='orcl1';
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_1_20091130011411.ORCL','service2','service1','SYS$SYS.KUPC$S_1_20091130011411.ORCL' SCOPE=MEMORY SID='orcl1';
Mon Nov 30 01:14:29 2009
DM00 started with pid=56, OS id=26976, job SYS.SYS_EXPORT_SCHEMA_01
At "SERVICE_NAMES" parameter:
SQL> show parameter service_namesAfter DATAPUMP finished. In alert log file:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string SYS$SYS.KUPC$C_1_20091130011411.ORCL, service2, service1, SYS$SYS.KUPC$S_1_20091130011411.ORCL
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_1_20091130011602.ORCL','service2','service1' SCOPE=MEMORY SID='orcl1';
ALTER SYSTEM SET service_names='service2','service1' SCOPE=MEMORY SID='orcl1';
At SERVICE_NAMES parameter:
SQL> show parameter service_namesDATAPUMP doesn't change existing service name and no impact to existing services.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string service2, service1
DATAPUMP just adds new services for its own queue operation.
read more metalink 363396.1
No comments:
Post a Comment