Friday, February 24, 2017

Oracle Direct DMP Back up

SQL> conn test2/test2@orcl
Connected.
SQL> host imp

Import: Release 11.2.0.1.0 - Production on Fri Feb 24 17:25:10 2017

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

Username: test2/test2@orcl

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Import data only (yes/no): no >

Import file: EXPDAT.DMP >

IMP-00002: failed to open EXPDAT.DMP for read
Import file: EXPDAT.DMP > E:\backup\HRM_190915.DMP

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by INVFGNSW, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no > y

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...