Solved

export/import function for oracle 7.3.4

Posted on 2007-03-20
3
4,125 Views
Last Modified: 2013-12-19
hello expert,

I have create a copy of the file i would like to export but


when i attempt to use the export command the following error is reported

foredba>exp ops$foredba/xxxxxx tables = close_hist_bkup file = closbkup.dmp
 
Message 206 not found; No message file for product=RDBMS, facility=EXP: Release7
 
Copyright (c) Oracle Corporatio
Export terminated unsuccessfully
 
EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP
EXP-00222: Message 222 not found; No message file for product=RDBMS, facility=E>



P.S i AM USING ORACLE 7.3.4

thanks
0
Comment
Question by:jomfra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Expert Comment

by:jwahl
ID: 18763007
maybe some export views are missing ... try to generate them as described here:

http://www.experts-exchange.com/Database/Oracle/Q_10176785.html

0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 18763976
Maybe it's a typo when you pasted but exp/imp really don't like spaces on it's parameters.

try:
exp ops$foredba/xxxxxx tables=close_hist_bkup file=closbkup.dmp
0
 
LVL 8

Accepted Solution

by:
sapnam earned 50 total points
ID: 18958431
sure you have the oracle client installed ? Can you see exp.exe in your bin folder ?  In Oracle 7.3, it was named exp73.  If you see the exe, just type exp and see whether Oracle prompts you for the details
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question