OraFAQ Forum: Server Utilities » Exporting schema using filesize parameter

Home » RDBMS Server » Server Utilities » Exporting schema using filesize parameter

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

Exporting schema using filesize parameter [message #562886]

Mon, 06 August 2012 11:44

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

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562891 is a reply to message #562886]

Mon, 06 August 2012 12:02

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

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

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562893 is a reply to message #562891]

Mon, 06 August 2012 12:04

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

@ Michel

faked session; post the REAL one. ??? could n't understand.

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562894 is a reply to message #562893]

Mon, 06 August 2012 12:07

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

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

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562896 is a reply to message #562894]

Mon, 06 August 2012 12:12

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

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562902 is a reply to message #562896]

Mon, 06 August 2012 12:54

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

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

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562903 is a reply to message #562902]

Mon, 06 August 2012 13:04

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

@ michal

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

Report message to a moderator

Re: Exporting schema using filesize parameter [message #562904 is a reply to message #562903]

Mon, 06 August 2012 13:25

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

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

Report message to a moderator

Previous Topic:	trunc function in sql loader
Next Topic:	SQL loader problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:22:12 CST 2025