8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Data Pump (expdp, impdp) Enhancements in Oracle Database 12c Release 2 (12.2)


Sharad said...

Tim,

Thanks for the helpful inputs regarding 12cR2 Data Pump Enhancements, these are really handy and helps in automating Refresh Scripts along with Optimizing Export/Import Jobs.

BRegards,
Sharad

Anonymous said...

Hi Tim,
After creating parfile, should we grant 'chmod 777 parfile.txt to run the export.
expdp parfile=/tmp/parfile.txt

Regards,

Tim... said...

Hi.

In the examples here the parfile is created by the same user as that running expdp, so it naturally has read permissions on the file. You don't need 777, just read.

Cheers

Tim...

Anonymous said...

Thank you

Anonymous said...

Hi Tim,

When I try to perform table export using parfile I get below error.
-bash-4.2$ expdp parfile=/tmp/parfile.txt

Export: Release 18.0.0.0.0 - Production on Mon Jul 26 05:44:19 2021
Version 18.5.0.0.0

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

UDE-12154: operation generated ORACLE error 12154
ORA-12154: TNS:could not resolve the connect identifier specified

Here is the parfile
-bash-4.2$ cat parfile.txt
USERID=demo/pwd@db1
directory=DMPDIR
dumpfile=exp_table_26072021.dmp
logfile=exp_table_26072021.log
CONTENT=DATA_ONLY
TABLES= table names,........

Oracle -- 18.0.0.0.0
OS -- CentOS Linux release 7.9.2009 (Core)
Env -- prod

Could you please suggest to solve this issue.

Regards

Tim... said...

Hi.

The error suggests you are trying to connect to the database using a TNS entry that is not present in the $ORACLE_HOME/network/admin/tnsnames.ora file. Add it and try again.

Cheers

Tim...

Anonymous said...

-bash-4.2$ tnsping RFDWVIT0
TNS Ping Utility for Linux: Version 18.0.0.0.0 - Production on 26-JUL-2021 13:45:15
Copyright (c) 1997, 2018, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name

I am sorry .
-bash-4.2$ tnsping demo

TNS Ping Utility for Linux: Version 18.0.0.0.0 - Production on 26-JUL-2021 13:45:15

Copyright (c) 1997, 2018, Oracle. All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name

Here is the tnsnames.ora

demo.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = demo)
)
(ADDRESS =
(PROTOCOL = TCP)
(HOST = servername)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = demo)
)
)

Regards

Sometime my post is disappeared. (I was saying I have created tnsnames.ora file ) -- This is my first reply.
when I try to perform tnsping demo, it fails with errors.

Regards,


Tim... said...

Hi.

Causes:
- You are not using "demo.world" in your parameter file for the connection.
- You are not editing the correct tnsnames.ora file on the database server.
- You are running the expdp command somewhere other than the database server.

If not those, I have no clue.

Cheers

Tim...

Anonymous said...

Hi Tim,
- You are not using "demo.world" in your parameter file for the connection.
Could you please suggest me how to user demo.world in parameter file.

- You are not editing the correct tnsnames.ora file on the database server.
I created tnsnames.ora file under $ORACLE_HOME/network/admin/tnsnames.ora and I modified this file.

- You are running the expdp command somewhere other than the database server.
I am running the command on the database server only.

Regards,

Tim... said...

Hi.

You must connect to the database to use export. You either do this on the command line, or using the USERID parameter in the parfile. Since you don't have it on the command line command you sent, I assume it is on the parfile. Use the value "username/password@demo.world" to connect to the correct database.

Cheers

Tim...

Anonymous said...

Thank you

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.