bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
Tag Import Export
Scenario is that we would like to export a schema called SWX residing on a Oracle 11.2.0.2 database running on…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
Transportable Tablespace across Different Platforms ___________________________________________________ In our example we will transport a tablespace called TEST. The tablespace should be…
1. Copy the backup of the dumpfile to the target server. 2. Create a tablespace in our eg: called TEST.…
—– Procedure to import table from production system to test system —— 1. Copy the backup(dump) of schema onto /backup_restor_only…