I know this is Oracle forum but does anyone know how to cast the
following into SQL SEREVER datetime ?
2005-07-04T21:23:52.8066529+01:00'
Regards
Harish
-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x10028519.[Email address protected]
Sent: 08 July 2005 15:31
To: LazyDBA Discussion
Subject: RE: IMP-00010: Not a valid export file
As indicated by Lloyd the buffer is a parameter, both in exports and
imports which tells how much data will be moved or worked with at one
time. This parameter should be changed to a higher number if you want to
have your export/import work faster. In your case it appears that you
may be trying to export a table whose row-length is more than the
default buffer size. If this is the case, just bump up the buffer
parameter to at least higher than the largest row length in your
database.
As regards the format of export and import files I agree that books say
the dmp files are in binary format and should be moved in bin format
while ftp'ing.
Gurmohan
www.freemath.info
-----Original Message-----
From: Lloyd Ruskin
[mailto:oracledba-ezmlmshield-x15242784.[Email address protected]
Sent: Friday, July 08, 2005 8:01 AM
To: LazyDBA Discussion
Subject: RE: IMP-00010: Not a valid export file
Buffer is one of the parameters on import. By entering imp help=Y you
get a list of all parameters:
Keyword Description (Default) Keyword Description (Default)
------------------------------------------------------------------------
--
USERID username/password FULL import entire file (N)
BUFFER size of data buffer FROMUSER list of owner
usernames
FILE input file (EXPDAT.DMP) TOUSER list of usernames
SHOW just list file contents (N) TABLES list of table names
IGNORE ignore create errors (N) RECORDLENGTH length of IO record
GRANTS import grants (Y) INCTYPE incremental import
type
INDEXES import indexes (Y) COMMIT commit array insert
(N)
ROWS import data rows (Y) PARFILE parameter filename
LOG log file of screen output
DESTROY overwrite tablespace data file (N)
INDEXFILE write table/index info to specified file
POINT_IN_TIME_RECOVER Tablespace Point-in-time Recovery (N)
SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)
ANALYZE execute ANALYZE statements in dump file (Y)
FEEDBACK display progress every x rows(0)
VOLSIZE number of bytes in file on each volume of a file on tape
To assist in your problem:
Set buffer length to a large number like 10Mb
Set commit=Y
Set ignore=Y (so you do not import objects already imported, if
necessary)
The use of a large buffer and commit will ensure no buffer overflow.
Hope this helps,
Lloyd
-----Original Message-----
From: JUANILLAS Jenny B.
[mailto:oracledba-ezmlmshield-x70169261.[Email address protected]
Sent: 08 July 2005 12:43
To: LazyDBA Discussion
Subject: RE: IMP-00010: Not a valid export file
Thanks. Now I encounter IMP-00032: SQL Statement exceeded buffer length.
How can I solve this? My OS is Win2K3.
Thanks.
-----Original Message-----
From: Ryan [mailto:oracledba-ezmlmshield-x26679230.[Email address
protected]
Sent: Friday, July 08, 2005 11:56 AM
To: LazyDBA Discussion
Subject: Re: IMP-00010: Not a valid export file
My mistake...
All .dmp files are binary so be sure to transfer them in binary format
Ryan
|---------+--------------------------------------------------------->
| | "JUANILLAS Jenny B. " |
| | <oracledba-ezmlmshield-x18276125.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | |
| | 08/07/2005 11:04 AM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------
--------------------------------------------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: IMP-00010: Not a valid export file
|
>-----------------------------------------------------------------------
--------------------------------------------------------|
Hi DBA Gurus,
I'm trying to import a dmp file in Windows platform, which I have
exported
in a Unix platform. But I'm getting this error message.
IMP-00010: not a valid export file, header failed verification
Pls. help. Thanks in advance.
Jenny
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date:
07/06/2005
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
________________________________________________________________________
_______
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure
by law.
Any claim to privilege is not waived or lost by reason of mistaken
transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the
sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data
corruption,
delay, interruption, unauthorised access or unauthorised amendment.
________________________________________________________________________
_______
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date:
07/06/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date:
07/06/2005
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**********************************************************
If you are not the intended recipient, employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination or copying of this communication and its attachments is strictly prohibited.
If you have received this communication and its attachments in error, please return the original message and attachments to the sender using the reply facility on e-mail.
Internet communications are not secure and therefore the UCLES Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the UCLES Group unless otherwise specifically stated.
The UCLES Group is getting a new look - we are adopting a new name and a new identity which expresses what we do more clearly - from July this year (2005) we will be trading as Cambridge Assessment.
**********************************************************
Oracle LazyDBA home page