Anda bisa menggunakan option QUERY, tapi hanya bisa pada "mode table" saja, tidak bisa pada "mode user".
Contoh di Linux, $ exp scott/tiger file=scott.dmp tables=emp,dept QUERY=\"where rownum\<=10\" Bowo --- In [email protected], jimmy <[EMAIL PROTECTED]> wrote: > > Pak yulius, > sekalian tanya donk, kalau mau export 1 user, dengan > masing2 table kita ambil 10 row saja gimana ya sintax > nya ? > > Thanks, > > --- Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > > > > COntoh kalau di platform Windows, dari MS-DOS Prompt > > > > C:\> exp system/oracle file=user1.dmp owner=user1 > > C:\> imp system/oracle file=user1.dmp fromuser=user1 > > touser=user2 > > > > > > CMIIW, > > > > Bowo > > > > > > > > > > > > --- In [email protected], "Mochamad Irwan > > Harahap" > > <MIrwan@> wrote: > > > > > > Dear Pipiet, > > > > > > Exp-imp tidak dijalankan dari sqlplus, tapi dari > > command prompt :) > > > > > > Thanks > > > > > > Best Regards, > > > Mochamad Irwan Harahap > > > > > > > > > -----Original Message----- > > > From: [email protected] [mailto:indo- > > [EMAIL PROTECTED] > > > On Behalf Of pipiet_faiz > > > Sent: Sunday, July 02, 2006 8:28 PM > > > To: [email protected] > > > Subject: [indo-oracle] Re: cara mengkopikan object > > dari schema lain > > > > > > > > > > > > klo pake perintah exp imp harus nginstall kyk > > plugin dulu g ? > > soalnya > > > saya coba jalanin perintah exp di sql plus ga bisa > > jalan > > (perintahnya > > > ga dikenalin), klo ada software tambahan yang > > perlu diinstal nama > > > packagenya apa ? thnx b4 :) > > > > > > ========================================================= > > > This e-mail, including any attachment is > > confidential and may be > > privileged. Use or disclosure of it by anyone other > > than an intended > > adressee is strictly prohibited. If you are not an > > intended > > addressee, please notify the sender by telephone or > > e-mail and > > delete the e-mail and any attachment from your > > system. > > > > > > PT Excelcomindo Pratama Tbk. ("the " Company") > > does not accept any > > liability in respect of communication made by its > > employee which is > > contrary to the company policy or outside the scope > > of the > > employment of the individual concerned. The employee > > responsible > > will be personally liable for any damages or other > > liability arising. > > > > > > ========================================================= > > > > > > > > > > > > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
