OraFAQ Forum: Server Utilities » Export table in multiple files

Home » RDBMS Server » Server Utilities » Export table in multiple files (Seven, Oracle 11gr2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export table in multiple files [message #587692]

Tue, 18 June 2013 02:48

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

Report message to a moderator

Re: Export table in multiple files [message #587694 is a reply to message #587692]

Tue, 18 June 2013 02:53

Littlefoot
Messages: 21825
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.

Report message to a moderator

Re: Export table in multiple files [message #587705 is a reply to message #587694]

Tue, 18 June 2013 03:23

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

Report message to a moderator

Re: Export table in multiple files [message #587706 is a reply to message #587705]

Tue, 18 June 2013 03:33

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Export table in multiple files [message #587707 is a reply to message #587705]

Tue, 18 June 2013 03:34

Littlefoot
Messages: 21825
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).

Report message to a moderator

Re: Export table in multiple files [message #587733 is a reply to message #587707]

Tue, 18 June 2013 05:30

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

Report message to a moderator

Re: Export table in multiple files [message #587735 is a reply to message #587733]

Tue, 18 June 2013 05:35

Littlefoot
Messages: 21825
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?

Report message to a moderator

Re: Export table in multiple files [message #587786 is a reply to message #587735]

Tue, 18 June 2013 11:51

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

Report message to a moderator

Re: Export table in multiple files [message #587787 is a reply to message #587786]

Tue, 18 June 2013 11:58

gio123
Messages: 6
Registered: June 2013

Junior Member

Hi,
Any suggestion will be well appreciated.

Thanks in advance.

Regards,

Giovanni

Report message to a moderator

Re: Export table in multiple files [message #587788 is a reply to message #587787]

Tue, 18 June 2013 12:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: Export table in multiple files [message #592372 is a reply to message #587788]

Wed, 07 August 2013 05:19

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,

Report message to a moderator

Previous Topic:	Multithreading not working with direct path load
Next Topic:	exp/imp failed on nasted table.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 15 22:08:48 CDT 2025