Home » RDBMS Server » Server Utilities » IMPORTING DUMP FILE (Oracle 10g)
IMPORTING DUMP FILE [message #502161] Tue, 05 April 2011 00:47 Go to next message
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 #502162 is a reply to message #502161] Tue, 05 April 2011 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 21624
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Full import will create tablespace(s).
Re: IMPORTING DUMP FILE [message #502164 is a reply to message #502162] Tue, 05 April 2011 01:10 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21624
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 Go to previous messageGo to next message
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 #502188 is a reply to message #502183] Tue, 05 April 2011 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should complete your question if you don't want inappropriate answer.

Regards
Michel
Re: IMPORTING DUMP FILE [message #502203 is a reply to message #502188] Tue, 05 April 2011 03:47 Go to previous messageGo to next message
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 #502204 is a reply to message #502203] Tue, 05 April 2011 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Before we ask some questions which may be infinite you should first give a COMPLETE picture of your environment.
For instance,
- do you change OS?
- do you change OS version?
- do you change Oracle version?
- what is your Oracle version?
- how do you do your export
- do you do it from client or server?
- what is your database character set?
- does it change?
- what is your client nls parameters?
- do you import from client or server?
- what the parallel settings?
- what is the OS of client?
- what is the OS version of client?
- what is the Oracle version of client?
- Is is the same client for export and import?
- what are the character set supported by the different OS you use?
- what are the time zone of all parts?

Have I to post all questions I can imagine?

Regards
Michel
Re: IMPORTING DUMP FILE [message #502207 is a reply to message #502204] Tue, 05 April 2011 04:12 Go to previous messageGo to next message
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 #502209 is a reply to message #502207] Tue, 05 April 2011 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All questions I posted are relavant to the question that is to be able to create the tablespace in the target database from the dump.

Regards
Michel
Re: IMPORTING DUMP FILE [message #502364 is a reply to message #502209] Wed, 06 April 2011 01:58 Go to previous messageGo to next message
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 #502366 is a reply to message #502364] Wed, 06 April 2011 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are wrong, yes character set may matter in your problem like the fact that, as LittleFoot said:
Quote:
You never said that a new server is different from the old one


Regards
Michel
Re: IMPORTING DUMP FILE [message #502368 is a reply to message #502366] Wed, 06 April 2011 02:20 Go to previous messageGo to next message
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 #502372 is a reply to message #502368] Wed, 06 April 2011 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can say that it is not always the case that import creates or does anything.

Regards
Michel
Re: IMPORTING DUMP FILE [message #502379 is a reply to message #502372] Wed, 06 April 2011 02:51 Go to previous messageGo to next message
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 #502385 is a reply to message #502379] Wed, 06 April 2011 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I didn't understand that you made the questions and the answers.

Regards
Michel
Re: IMPORTING DUMP FILE [message #502391 is a reply to message #502161] Wed, 06 April 2011 03:31 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13895
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?
Re: IMPORTING DUMP FILE [message #502416 is a reply to message #502405] Wed, 06 April 2011 04:22 Go to previous message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
He PMed me his opinion.
The subject is closed.

Regards
Michel
Previous Topic: SQL LOADER: format of an error returned by a command line
Next Topic: error in load data using sqlloader
Goto Forum:
  


Current Time: Thu Dec 03 22:27:11 CST 2020