Home » RDBMS Server » Server Utilities » Exporting schema using filesize parameter
Exporting schema using filesize parameter [message #562886] Mon, 06 August 2012 11:44 Go to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ hi to all ;

Export /Import
==============

While exporting schema's

i couldn't export dump file to exact location i mean see following query : -

QUERY
=====

exp file=\backup\file1.dmp,\backup\file2.dmp,\backup\file3.dmp 
owner=(order,purchase) filesize=5m as os level ,

I fould those dump files files  home directory.

-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile1.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile2.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile3.dmp

[oracle@localhost ~]$ pwd
/home/oracle 



when i listing
rw-r--r-- 1 oracle oinstall 72 Jun 20 21:17 afiedt.buf
drwxr-xr-x 3 oracle oinstall 4096 Jun 17 10:07 Desktop
-rw-r--r-- 1 oracle oinstall 71 Jun 19 20:42 ed.hup
drwxr-xr-x 2 oracle oinstall 4096 Aug 6 19:38 backup
-rw-r--r-- 1 oracle oinstall 2826240 Aug 6 19:39 expdat.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile1.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile2.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile3.dmp

Dump file goes to home path even if i mentioned appropriate location.

Thanks in advance
Re: Exporting schema using filesize parameter [message #562891 is a reply to message #562886] Mon, 06 August 2012 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
exp file=\backup\file1.dmp,\backup\file2.dmp,\backup\file3.dmp
owner=(order,purchase) filesize=5m as os level ,

I fould those dump files files home directory.

-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile1.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile2.dmp
-rw-r--r-- 1 oracle oinstall 5242880 Aug 6 19:38 expfile3.dmp

This is a faked session; post the REAL one.

Regards
Michel
Re: Exporting schema using filesize parameter [message #562893 is a reply to message #562891] Mon, 06 August 2012 12:04 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ Michel

faked session; post the REAL one. ??? could n't understand.
Re: Exporting schema using filesize parameter [message #562894 is a reply to message #562893] Mon, 06 August 2012 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Youd could not get what you say you got with the command you said you executed.
So post what you actually did that is COPY AND PASTE your session.
Is this clear?

Regards
Michel
Re: Exporting schema using filesize parameter [message #562896 is a reply to message #562894] Mon, 06 August 2012 12:12 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ Michel

We are facing issues " copy and paste " so what ??? please clarify still we are struggling can't understand this work.
One member posting question who got error from our team. This is not fake. Then your wish.

Thank you;
Thiyagusham.G
Re: Exporting schema using filesize parameter [message #562902 is a reply to message #562896] Mon, 06 August 2012 12:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I said: "You could not get what you say you got with the command you said you executed"
So, currently, there is no REAL issue.
So, maybe we should end the topic?

Regards
Michel
Re: Exporting schema using filesize parameter [message #562903 is a reply to message #562902] Mon, 06 August 2012 13:04 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ michal

Ok but i didn't get answer. Thanks michal.

Re: Exporting schema using filesize parameter [message #562904 is a reply to message #562903] Mon, 06 August 2012 13:25 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't get an answer because there is no real question so no answer is possible.
Post a real question and you will have some answers.

Regards
Michel
Previous Topic: trunc function in sql loader
Next Topic: SQL loader problem
Goto Forum:
  


Current Time: Fri Mar 29 09:23:43 CDT 2024