The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Operating Systems > SUN Solaris
exporting a dmp file (oracle)from unix exporting a dmp file (oracle)from unix
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


SUN Solaris The Solaris Operating System, usually known simply as Solaris, is a free Unix-based operating system introduced by Sun Microsystems .

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
exporting variabels from env file dsravan Shell Programming and Scripting 1 11-30-2007 01:57 PM
alert_oss.log oracle log file in hp-unix Assassin Shell Programming and Scripting 3 05-01-2007 09:30 PM
Exporting files from unix to Excel sheet bishweshwar UNIX for Advanced & Expert Users 3 03-21-2007 04:41 AM
Exporting text file data to csv l_jayakumar Shell Programming and Scripting 3 09-19-2005 12:27 AM
Crontab job for exporting a Oracle database c.d.israel UNIX for Dummies Questions & Answers 1 10-24-2002 04:48 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 02-05-2004
etravels etravels is offline
Registered User
  
 

Join Date: Nov 2003
Posts: 12
exporting a dmp file (oracle)from unix
i want to export a database (full schema) so that I can import the database to a windows 2000 server. The database is sitting on a unix-sun solaris box ver 8.. What are the commands...

I am a bit rusty at unix at the moment!

Cheers
E
  #2 (permalink)  
Old 02-05-2004
jsilva's Avatar
jsilva jsilva is offline
Registered User
  
 

Join Date: Apr 2003
Posts: 169
Hi,

The exp and imp commands are pretty much the same on unix or windows...

To do a full export:
( the user can be any user with DBA role )

exp SYSTEM/passwd FULL=y FILE=database_export.dmp GRANTS=y ROWS=y
  #3 (permalink)  
Old 02-05-2004
etravels etravels is offline
Registered User
  
 

Join Date: Nov 2003
Posts: 12
cheers...exp/imp
hiya

thanks, I thought as much,....

Also how to copy the file from the unix box onto my c drive?

I have created a test.dmp file and I can see it on the /home/oradev directory....
I would like tocopy it to a network drive? is this possible?

Cheers

E
  #4 (permalink)  
Old 02-05-2004
jsilva's Avatar
jsilva jsilva is offline
Registered User
  
 

Join Date: Apr 2003
Posts: 169
You can share the /home/oradev directory using samba... or, more easily, just activate the FTP server on the unix machine ( see /etc/inetd.conf ) and transfer the file, using an ftp client on the windows machine...
  #5 (permalink)  
Old 02-05-2004
etravels etravels is offline
Registered User
  
 

Join Date: Nov 2003
Posts: 12
cool on exp
Thanks a million, already feeling an expert.....
what do you do ?

E
Closed Thread

Bookmarks

« About raw partition | Device PS1 AC UNAVAILABLE »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 12:48 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0