469,631 Members | 1,442 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Help with Import ORACLE

Hello,

I have a little problem with an oracle import.
My problem is :

1) I have a dump (file.dmp) contains a table T1 (just for this
example)
2) I have an oracle schema (user=U1, pass=pass1) contains a table T2
with the same structure as T1
but having different tablespace (data,index) and with different
pctFree and pctUsed.
3) I would like to import the file file.dmp in this schema

___

the command
imp U1/pass1 file=file.dmp doesn't work because the table is already
exist
the command
imp U1/pass1 file=file.dmp ignore=Y doesn't work
Thank you for help

MB
Jul 19 '05 #1
1 19677
mb@asterop.com (M Bouloussa) wrote in
news:ab*************************@posting.google.co m:
Hello,

I have a little problem with an oracle import.
My problem is :

1) I have a dump (file.dmp) contains a table T1 (just for this
example)
2) I have an oracle schema (user=U1, pass=pass1) contains a table T2
with the same structure as T1
but having different tablespace (data,index) and with different
pctFree and pctUsed.
3) I would like to import the file file.dmp in this schema

___

the command
imp U1/pass1 file=file.dmp doesn't work because the table is already
exist
the command
imp U1/pass1 file=file.dmp ignore=Y doesn't work
Thank you for help

MB


You post leave out many details.
OS
OS version
Oracle version
"doesn't work" is like telling the doctor you don't feel well.
Do you realize how many different ways it "doesn't work" might happen?
Why can't/don't/won't you post EXACTLY what you got via cut & paste?
Have you tried
imp help=yes
Is/was table T1 owned by U1?
Do you have "DBA privs"?
What should happen to the existing data?
If PK/UK is on this table what is to be done with duplicates?
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by GrayGeek | last post: by
5 posts views Thread by duikboot | last post: by
4 posts views Thread by Azhar Bilgrami | last post: by
3 posts views Thread by tracy | last post: by
1 post views Thread by Arti Potnis | last post: by
reply views Thread by msansari | last post: by
1 post views Thread by M Bouloussa | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.