473,320 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Oracle import utility does not import anything

Hi,

I have a Oracle 9 dump file with me with user "plus10". I would like to import everything present in this file into my database. I do not have any idea about the tablespace this was exported from. I used following command:

imp system/<pass> file=plus10.dmp fromuser=plus10 touser=system ignore=y

The output says:
Export file created by EXPORT:V09.02.00 via conventional path

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

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion). importing PLUS10's objects into SYSTEM
Import terminated successfully without warnings.

I have "plus10" user created in my database. When I search for the tables in my system account, it does not show the tables imported. Also when I use the following command:

imp system/<pass> file=plus10.dmp full=y ignore=y

It says, imp failed due to duplicate object "table-name" in the database.

What is the problem with Oracle then? I am new to Oracle so I am not able to solve this. I just love MS SQL. Oracle sucks big time.
May 20 '10 #1
2 3300
Expand|Select|Wrap|Line Numbers
  1. Export file created by EXPORT:V09.02.00 via conventional path
  2.  
  3. Warning: the objects were exported by PLUS10, not by you
  4.  
  5. import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion). importing PLUS10's objects into SYSTEM
  6. Import terminated successfully without warnings.
  7.  
If that's the entire output you got, your .dmp file is not holding any objects. What were the export statement and log ?

Btw: welcome to the world of real databases ...
May 20 '10 #2
debasisdas
8,127 Expert 4TB
May i know why you imported to system schema and to other normal user schema ?
May 24 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Jack | last post by:
Hi I am just trying to get a feel for what oracle SQL syntax there is that would not be covered at all in anyway from a functionality perspective in the standard ANSI SQL.. Any input is...
6
by: davvid | last post by:
hello, please I would like to know if it's possible to load data in hierarchical table structure with identity column used as pk (for all the tables) : I mean table root (Id_root(pk,identity...
1
by: Joe Philip | last post by:
I created a file called data.del using export like this: export to data.del of del select * from sy9.c001 Now, I want to import this data to a different database into a different table. This...
1
by: plaul1 | last post by:
I am going to be using the export utility to export large amts of data out of UDB. Does anyon have any benchmark numbers available. What is the rule of thumb, how many gig/hr/cpu can be exported...
0
by: hikums | last post by:
Could it be that if I have a ESE on client and access WSE on Server, the load utility from control center not work? If I run it from command line/command center, it works fine. How do I debug?...
1
by: pw | last post by:
Hi, Does one exist? Our application is in Access 97 (I would spend the time to get it converted into Access 2003 if it was worth the frustration). A client would like some of his members to be...
4
by: db2group88 | last post by:
hi, we are using db2 v8.2 Express on Windows, I try to import the rows into a table which is being used ( maybe being read or write), and it was kicked out because there is lock waiting. As our...
2
by: Joel Hedlund | last post by:
Hi! I have a possibly dumb question about imports. I've written two python modules: parser.py ------------------------------------ class Parser(object): "my parser"...
0
by: kswamynathan | last post by:
Hi, If u r using Oracle 9i relaease 2 DB or Oracle 9Ias release 2 , there is no need to change the oraparam.ini. ( Even if urs is P4 machine ). If u have added the -nojit parameter, revoke...
7
by: Ivan | last post by:
Hello group! I need to create import utility. My main concern is how will I support multiple file types. XLS, CVS, etc? Is there any libraries I can use and distribute (part of framework?) That...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.