Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Size of databse, dmp files have differnces after exp and ftp

10438Sep 2 2004 — edited Sep 3 2004

Source OS : Sun Microsystems Inc. SunOS 5.5.1

My actual size of the database are as follows:

SQL> select sum(bytes) from dba_data_files;

SUM(BYTES)
----------
3227516928

But size of my dmp file is as follows:

dhs3 41: ls -ltr dawar.dmp
-rw-r--r-- 1 oracle7 dba 51577856 Sep 2 12:07 dawar.dmp

Here what I got in Linux server (Destination) after FTP

oracle@dhshrwits:~/Documents> ls -ltr dawar.dmp
-rw-r--r-- 1 oracle oinstall 51563371 2004-09-02 12:38 dawar.dmp

All sizes have some differences.

Case Study:
My goal is to export entire database, oracle 7.3.4 from sunOS 5.5.1. and put in the Linux server through ftp.
The file name is dawar.dmp which contains all data.

I tested exp and ftp.

Please confirm my all steps.
I did telnet to my Sun Box from Linux Sever.
Logon to sqlplus on Sun OS via telnet where Oracle 7.3.4 existed.

Connected to: Oracle7 Server Release 7.3.4.5.0 - Production
With the parallel query option
PL/SQL Release 2.3.4.5.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > dawar.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1

Export grants (yes/no): yes > yes

Export table data (yes/no): yes > yes

Compress extents (yes/no): yes >

Export done in US7ASCII character set

About to export the entire database ...
. exporting tablespace definitions
....................
.................

Export terminated successfully without warnings.

dhs3 41: ls -ltr dawar.dmp
-rw-r--r-- 1 oracle7 dba 51577856 Sep 2 12:07 dawar.dmp

exit from sqlplus and telnet sun OS.

Now from Linux server I run ftp from the directory I like to transfer dawar.dmp as:
oracle@dhshrwits:~/Documents> ftp ipaddress of Sun OS
Logon as a Oracle user.

ftp> get dawar.dmp
local: dawar.dmp remote: dawar.dmp
227 Entering Passive Mode (159,225,155,29,146,23)
150 ASCII data connection for dawar.dmp (159.225.140.75,36190) (51577856 bytes).
226 ASCII Transfer complete.
51879696 bytes received in 19:54 (42.41 KB/s)
ftp> exit

File has transfer to the Linux Server.

LINUX SERVER (DESTINATION)
oracle@dhshrwits:~/Documents> ls -ltr dawar.dmp
-rw-r--r-- 1 oracle oinstall 51563371 2004-09-02 12:38 dawar.dmp
oracle@dhshrwits:~/Documents>

Am I missing any thing in the whole process?
If not, so why the size has of a db has big difference than dawar.dmp?

Any feedback will be appreciated.

Regards,
D
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2004
Added on Sep 2 2004
7 comments
273 views