Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Export without any Table Data...why?
>database is a very big one. I want the export for backup...
You might explain what you mean by "backup." Oracle does not recommend using exp for backup. See the backup and recovery guide about physical and logical backups. You might also define what you mean by "very big," as some of us decide it makes more sense to work on the server itself for "medium" sized databases.
Since you successfully do this from another PC, I wonder if you have something dreadfully misconfigured on your PC, such as @database pointing somewhere different in your tnsnames.ora or with TWO_TASK environment variables.
If your server has $ORACLE_HOME/network/log/listener.log, you might look and see if you are attaching as expected.
And what David said.
jg
-- @home.com is bogus. "HEAD HUNTERS AND RELATED EMPLOYMENT SERVICES TAKE NOTE: YOU SHOULD NOT CALL OR APPLY; YOU WILL BE TREATED RUDELY, MOCKED, TARRED AND FEATHERED IF YOU DO; YOUR SERVICES ARE NOT REQUIRED. THANK YOU." - From job posting.Received on Fri May 13 2005 - 15:08:07 CDT