Home » RDBMS Server » Server Utilities » Export table in multiple files (Seven, Oracle 11gr2)
Export table in multiple files [message #587692] Tue, 18 June 2013 02:48 Go to next message
gio123
Messages: 6
Registered: June 2013
Junior Member
Hi All,
I'm stuck to an issue in exporting a big table (many rows = 3.000.000). Using the command exp the error message returned is "expdat.dmp > EXP-00028: failed to open expdat.dmp for write".
Is there a possibility to export this table in multiple files (as a splitter)?

Thanks in advance for your kind support.

Regards,

Giovanni
Re: Export table in multiple files [message #587694 is a reply to message #587692] Tue, 18 June 2013 02:53 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
3 million records is kind of small.
Oracle

EXP-00028: failed to open string for write

Cause: Export failed to open the export file for writing. This message is usually followed by device messages from the operating system.

Action: Take appropriate action to restore the device.
Re: Export table in multiple files [message #587705 is a reply to message #587694] Tue, 18 June 2013 03:23 Go to previous messageGo to next message
gio123
Messages: 6
Registered: June 2013
Junior Member
Hi,
thanks for the quick reply.

Any idea about the solution of this issue? Is there the possibility to export only a minimum number of rows? I have verified the permissions for writing and it's ok. Maybe the problem is in writing the dump file. For tables with few rows, the export into csv file is ok pressing the right click and selecting the export into csv file.

Thanks in advance for your kind support.
Regards,

Giovanni
Re: Export table in multiple files [message #587706 is a reply to message #587705] Tue, 18 June 2013 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 58529
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any idea about the solution of this issue?


Check the target directory exists and you have write access to it and it is not full.

Quote:
I have verified the permissions for writing and it's ok.


What and how did you check exactly. Copy and paste what you do and get starting from the export command and its error.
This is the starter to help you.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Use code tags.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel
Re: Export table in multiple files [message #587707 is a reply to message #587705] Tue, 18 June 2013 03:34 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there enough space on the disk? Do you use disk quotas?

As of a "minimum number of rows": research use of the QUERY parameter, which is a select clause used to export a subset of a table (so you can create a WHERE clause and restrict number of records).
Re: Export table in multiple files [message #587733 is a reply to message #587707] Tue, 18 June 2013 05:30 Go to previous messageGo to next message
gio123
Messages: 6
Registered: June 2013
Junior Member
Hi,
thanks for the cooperation.

More exacltly, after the login the command is the following.

SQL>$exp scott/tiger2 file=hist.dump log=hist.log tables=HIST_NOBILLING_TOT rows=yes indexes=no

Launching this command the messages are the following
Export: release 11.2.0.1.0 - Production on xxxx....
Copyright (c) 1982 .......

EXP-00028: <text message>
SQL>

Any help will be well appreciated.

Thanks.

Regards,

Giovanni
Re: Export table in multiple files [message #587735 is a reply to message #587733] Tue, 18 June 2013 05:35 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is not really a copy/paste, is it? Why did you omit certain parts that might be interesting and help narrow the problem? You aren't charged by number of characters you post here, are you?
Re: Export table in multiple files [message #587786 is a reply to message #587735] Tue, 18 June 2013 11:51 Go to previous messageGo to next message
gio123
Messages: 6
Registered: June 2013
Junior Member
Hi,
ok, this is the complete message returned in executing the export command.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> $exp scott/tiger2 file=hist.dmp log=hist.log tables=HIST_NOBILLING_xxx rows=yes indexes=no

Export: Release 11.2.0.1.0 - Production on Mar Giu 18 11:49:09 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

EXP-00028: Opening in writing hist.log failed (message translated from Italian to English)
EXP-00000: Export operation has terminated with error (message translated from Italian to English)

In my opinion is it possible to export this table (3.000.000 rows) into a csv file?

Any help will be well appreciated.
Thanks,

Giovanni
Re: Export table in multiple files [message #587787 is a reply to message #587786] Tue, 18 June 2013 11:58 Go to previous messageGo to next message
gio123
Messages: 6
Registered: June 2013
Junior Member
Hi,
Any suggestion will be well appreciated.

Thanks in advance.

Regards,

Giovanni
Re: Export table in multiple files [message #587788 is a reply to message #587787] Tue, 18 June 2013 12:05 Go to previous messageGo to next message
BlackSwan
Messages: 22490
Registered: January 2009
Senior Member
We don't know Operating System name or version since you decided to not share those details with us.
problem is OS related.
Does OS User have OS Write permission to create the file in the Current Directory?
Does OS file system have sufficient free disk space to accept this new file?
Re: Export table in multiple files [message #592372 is a reply to message #587788] Wed, 07 August 2013 05:19 Go to previous message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
i think table size is yet to be known using dba_segments view, and then check with disk space availability, more free space required for the export dump,
Previous Topic: Multithreading not working with direct path load
Next Topic: exp/imp failed on nasted table.
Goto Forum:
  


Current Time: Thu Jul 24 08:46:14 CDT 2014

Total time taken to generate the page: 0.68187 seconds