Re: exporting table
Posted by:
Sean Nolan
Date: April 01, 2005 10:27AM
According to the documentation for SELECT ... INTO OUTFILE, the file must not exist, so if it does exist you'll need to delete it before you run the statement. Here is the quote from the docs:
"The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. The file cannot currently exist, which among other things prevents files such as /etc/passwd and database tables from being destroyed."
Sean
Subject
Written By
Posted
Re: exporting table
April 01, 2005 10:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.