Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem with dp import

580524Sep 23 2008 — edited Mar 4 2013

Goodmorning! (local time in the netherlands)

Hope someone can help me with this: On a 10.2.0.3.0 test machine there are 3 databases in which imports can be made from the 3 databases on the production system. I have created a 4th test database and would like to do the same import as I did yesterday to another test database on the same machine. I copied the scripts and par files, modified the database name and location, but I get the following error when I run the script:
ORA-12154: TNS:could not resolve the connect identifier specified

The database was created with the following statement:

create database GT_WOZ datafile '/oradata/gt-woz/gtdata.dbf' size 3 G autoextend on default temporary tablespace gttemp tempfile '/oradata/gt-woz/gttemp.dbf' size 1 G undo tablespace gtundo datafile '/oradata/gt-woz/gtundo.dbf' size 1 G sysaux datafile '/oradata/gt-woz/gtsaux.dbf' size 100 M autoextend on;

Besides changing sys and system passwords, I have not made any changes to the database. The script I want to run imports 3 schemas. All suggestions are welcome!

Thanks in advance,
Marcel van der Sar