DBA Hub

📋Steps in this guide1/1

LOGTIME=ALL parameter in datapump of oracle 12c - DBACLASS DBACLASS

LOGTIME :Specifies that messages displayed during export operations be timestamped. It has been introduced in oracle 12c. Valid keyword values are: ALL, [NONE], LOGFILE and STATUS.   EXAMPLE: [oracle@localhost ~]$ expdp dumpfile=logdump.dmp logfile=viewlog.log directory=DUMP schemas=TEST logtime=ALL Export: Release 12.1.0.2.0 - Production on Sat Aug 22 07:19:41 2015 Copyright (c) 1982, 2014, Oracl

oracle clusteringintermediate
by OracleDba
11 views
1

Overview

LOGTIME :Specifies that messages displayed during export operations be timestamped. It has been introduced in oracle 12c. Valid keyword values are: ALL, [NONE], LOGFILE and STATUS. EXAMPLE:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
[oracle@localhost ~]$ expdp dumpfile=logdump.dmp logfile=viewlog.log directory=DUMP schemas=TEST logtime=ALL

Export: Release 12.1.0.2.0 - Production on Sat Aug 22 07:19:41 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: sys/oracle@ORCL as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
22-AUG-15 07:19:51.752: Starting "SYS"."SYS_EXPORT_SCHEMA_02":  sys/********@ORCL AS SYSDBA dumpfile=logdump.dmp logfile=viewlog.log directory=DUMP schemas=TEST logtime=ALL 
22-AUG-15 07:19:52.687: Estimate in progress using BLOCKS method...
22-AUG-15 07:19:55.163: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
22-AUG-15 07:19:55.244: Total estimation using BLOCKS method: 39 MB
22-AUG-15 07:19:55.776: Processing object type SCHEMA_EXPORT/USER
22-AUG-15 07:19:55.937: Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
22-AUG-15 07:19:55.971: Processing object type SCHEMA_EXPORT/ROLE_GRANT
22-AUG-15 07:19:56.014: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
22-AUG-15 07:19:56.687: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
22-AUG-15 07:20:05.095: Processing object type SCHEMA_EXPORT/TABLE/TABLE
22-AUG-15 07:20:08.467: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
22-AUG-15 07:20:08.719: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
22-AUG-15 07:20:20.538: . . exported "TEST"."TEST"                               10.66 MB   93925 rows
22-AUG-15 07:20:20.763: . . exported "TEST"."TEST2"                              10.66 MB   93937 rows
22-AUG-15 07:20:21.072: . . exported "TEST"."TEST3"                              10.66 MB   93938 rows
22-AUG-15 07:20:21.926: Master table "SYS"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
22-AUG-15 07:20:21.928: ******************************************************************************
22-AUG-15 07:20:21.929: Dump file set for SYS.SYS_EXPORT_SCHEMA_02 is:
22-AUG-15 07:20:21.932:   /home/oracle/DUMP/logdump.dmp
22-AUG-15 07:20:21.957: Job "SYS"."SYS_EXPORT_SCHEMA_02" successfully completed at Sat Aug 22 07:20:21 2015 elapsed 0 00:00:32

[oracle@localhost ~]$

Comments (0)

Please to add comments

No comments yet. Be the first to comment!