| IMPORTING DUMP FILE [message #502161] |
Tue, 05 April 2011 00:47  |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
I just want to ask if I need to create table spaces which are not existing in the database that I will be importing my dump file.
Example
Database 1 has table A and located in table space X. What will happen if I create a full export for Database 1 and I do a full import in Database 2 which doesn't have table space X?
Will table A still be imported? if yes what will be it's table space? if no, do I have to see the error logs of my import then create table space x for my database 2 and try to export again?
|
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502164 is a reply to message #502162] |
Tue, 05 April 2011 01:10  |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
if the disks on the new server are set up differently from the source server, the full import will fail to create the necessary tablespaces.
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502166 is a reply to message #502164] |
Tue, 05 April 2011 01:29 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
You never said that a new server is different from the old one.
According to the documentation:Oracle
the import will create the corresponding datafiles in the same file structure as at the source database, which may not be compatible with the file structure on the target system
[Updated on: Tue, 05 April 2011 01:30] Report message to a moderator |
|
|
|
| Re: IMPORTING DUMP FILE [message #502183 is a reply to message #502166] |
Tue, 05 April 2011 03:05 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
I also did not say that it has the same file structure as the old one. You should have completed your answer and not just said that "Full import will create tablespace(s)." because that is not always the case.
|
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502203 is a reply to message #502188] |
Tue, 05 April 2011 03:47 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
It doesn't hurt if you guys will ask some clarifications in order to give the appropriate answer. It is also not difficult to explain that "Full import will create tablespace(s)." is not always true.
|
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502207 is a reply to message #502204] |
Tue, 05 April 2011 04:12 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
you seem sarcastic now. you can just post questions/clarifications that would be most relevant to the problem. My point is if you know your answer will not be applicable to considerable number of situations why not explain bit further.
Anyway I don't want to argue with you michel because I don't want my posts to be deleted again.
thanks anyway.
|
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502364 is a reply to message #502209] |
Wed, 06 April 2011 01:58 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
Are you reading my post? I said MOST relevant questions/clarifications. Although those questions are important in doing import/export in general, some of them have lesser relevance with respect to the problem given.
In my example I'm just asking if table A will be imported even if it belongs to a tablespace not existing in the new database.
So why will you ask about database character set? if there is a problem in character set it doesn't matter if you have the same tablespaces or not.The same case with version problems.
|
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502368 is a reply to message #502366] |
Wed, 06 April 2011 02:20 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
But the main focus of the problem is about the non-existence of tablespace. If there is conflict/problem in the character set it doesn't matter if you have same tablespaces or not it will remain a problem that is my point. The same as the version etc. I can even go beyond that and say that my computer also matters because if it doesn't boot up I will not be able to do import/export.
Yes I also did not say that it is the same as the old one. So why answer categorically that Full import will create tablespace(s) where in it is not always the case?
It's like saying that if you want to get rich be a businessman. Is this always the case? the answer is no.
[Updated on: Wed, 06 April 2011 02:21] Report message to a moderator |
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502379 is a reply to message #502372] |
Wed, 06 April 2011 02:51 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
Our premise is if "Full import will create tablespace(s)."
Which is more relevant to the problem?
Your arguments
Not always the case because--
Full import will create tablespace(s) is not always the case because you have to consider versions, character sets etc.
"I can say that it is not always the case that import creates or does anything."
My argument
Not always the case because--
if the disks on the new server are set up differently from the source server, the full import will fail to create the necessary tablespaces.
Even a 10 year old boy will find your argument sarcastic.
[Updated on: Wed, 06 April 2011 03:00] Report message to a moderator |
|
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502391 is a reply to message #502161] |
Wed, 06 April 2011 03:31 |
xpact83
Messages: 225
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
I just quoted your messages I did not make those. Stay on the topic do you still believe that your two arguments there are more relevant than mine regarding the statement of littlefoot?
The problem here is, if michel run out of arguments he will just delete my post and even suspend my account.
|
|
|
|
| Re: IMPORTING DUMP FILE [message #502405 is a reply to message #502391] |
Wed, 06 April 2011 04:03 |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
No Michel will not do that.
Now can the pair of you knock this off and concentrate on addressing any actual oracle issues you may be having?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
