Home » RDBMS Server » Backup & Recovery » date time changes (oracle 10g,xe)
date time changes [message #488916] Wed, 12 January 2011 04:28 Go to next message
shrikant1987
Messages: 13
Registered: October 2010
Location: INDIA
Junior Member

Dear All


I m facing a problem while importing dump on oracle 10g ,the time of some record is changed.
I m exporting the data from oracle xe.
I m using normal imp/exp command for import and export,
please guide me.


With Warm Regards
Shrikant
Re: date time changes [message #488921 is a reply to message #488916] Wed, 12 January 2011 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which time are you talking about?
How do you export (post command)?
How do you import (post command)?

Regards
Michel
Re: date time changes [message #488940 is a reply to message #488921] Wed, 12 January 2011 07:00 Go to previous messageGo to next message
shrikant1987
Messages: 13
Registered: October 2010
Location: INDIA
Junior Member


Time when the records are generated in local database(xe).
is changed when i insert it to main server(10g)


for export i use:exp user/user file=d:/backup/container.dmp statistics=none
for importing :
CREATE USER container IDENTIFIED BY container
:
after giving necessary Grants
:
host imp system/pass@orcl fromuser=user touser=container file=D:\Scprit_naka_octroi\container.dmp log=D:\Scprit_naka_octroi\container.log statistics=recalculate Ignore=y;

[Updated on: Wed, 12 January 2011 07:03]

Report message to a moderator

Re: date time changes [message #488943 is a reply to message #488940] Wed, 12 January 2011 07:04 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Which time are you talking about?


Regards
Michel
Re: date time changes [message #489648 is a reply to message #488943] Tue, 18 January 2011 05:47 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hey Michel,

I want to know that the command which shrikant has used ie.
imp system/pass@orcl fromuser=user touser=container 
file=D:\Scprit_naka_octroi\container.dmp 
log=D:\Scprit_naka_octroi\container.log statistics=recalculate Ignore=y;
usually we use "fromuser and touser" or user/password but using both "fromuser and touser" and user/passord at the same time is it feasible?

Thanks
Deepak

[Updated on: Tue, 18 January 2011 06:39] by Moderator

Report message to a moderator

Re: date time changes [message #489656 is a reply to message #489648] Tue, 18 January 2011 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is.

Regards
Michel
Re: date time changes [message #489664 is a reply to message #489656] Tue, 18 January 2011 06:59 Go to previous messageGo to next message
shrikant1987
Messages: 13
Registered: October 2010
Location: INDIA
Junior Member

sir
the column named arrival_date in localdb(oracleXe)saves the date&time at which the record is created and saved.

after inserting the data in maindb(oracle 10g) with the same column name arrival_date the time of some of the records is changed(the am changes to pm).

Re: date time changes [message #489669 is a reply to message #489664] Tue, 18 January 2011 07:45 Go to previous message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Datatype of arrival_date?
NLS settings? In all places, servers and clients.
Is there any trigger on the table?
In all cases, neither exp nor imp changes the data but possibly character in CHAR family fields depending on the used character sets.

Regards
Michel
Previous Topic: Trying to understand EXP error
Next Topic: Incremental Level Backup
Goto Forum:
  


Current Time: Sat Feb 27 01:44:06 CST 2021