-
Export / Import
Hi,
I need to export and then import a 200 GB database.
Help me to identify this.
- How big the DMP file will be ?
- How much time it will take, how can I calculate this based on what all parameters.
- What considerations I need to make for Export and Import in terms on Rollback Segments, Temp Tablespace.
Anything else you want me to look into.
This is Really urgent.
Regards
Vijay
--------------------------
The Time has come ....
-
try tablespace export
Hi
200 GB is quite massive. I guess you should try alternatives like tablespace exports i.e., exporting each tablespace individually. Atleast you will be able to break up a really big job into smaller pieces.
Burzin
-
Maybe a FULL tablespace export with ROWS=N..
and then break it into smaller exports.. i.e. via tables or users.
Create a new "empty" database. Perform a full import... and then import the other data over a period of time.
Also, if you ae using unix, you might want to gzip on the fly through a named_pipe to reduce the export file size.
OCP 8i, 9i DBA
Brisbane Australia
-
If it is Unix, check this from metalink:
o How to calculate the size of your export?
If the site is unsure how large a resultant export file will be, they
can use the following commands to calculate its size:
(1) Create a unix named pipe:
% mknod /tmp/exp_pipe p
(2) Start the export in the background, specifying the named pipe as
the output file:
% exp file=/tmp/exp_pipe &
(3) Next, dd in from the named pipe, out to /dev/null in 1K blocks:
% dd if=/tmp/exp_pipe of=/dev/null bs=1024
(4) This will return the size of the export file in 1K blocks as
follows:
+0 records in
+0 records out
Cheers
Angel
-
Hi,
I m on NT.
Another thing is that, I am on SAP and it has logical concept of clients means in almost all tables there is a field called client and which differs according to the data related to a client.
Now i want to import all the client specific data (which can be found based on a field in a table) to our QA server.
What could be option available in Oracle.
Do I need to look into rollback segments and temporary tablespace on database from which i m exporting ?
Help me.
vijay
Last edited by vijay8282; 11-08-2002 at 06:43 AM.
--------------------------
The Time has come ....
-
Out of the 200 gigs how much is actually used?
That will determine the size of the export. Also, you can disregard your indexes since only their DDL gets exported.
One way is to try it out, if it bombs delete the .DMP and try again.
MH
I remember when this place was cool.
-
Hi,
Actually table data is some 118 GB and index data is around 70 GB.
U men that only 118 Gb wll get exported and not 70Gb of indexes ?
bye
vijay
--------------------------
The Time has come ....
-
Can you specify the filesize and compress the files as they are created? If you do it once you will have a better appreciation for how large your database really is. You can also do an analyze compute, maybe over a weekend. then you will have good stats to add up all of the extents. you could use the DBMS_SPACE package to calculate how much is really there. Compared with how much is allocated.
-
Originally posted by vijay8282
Now i want to import all the client specific data (which can be found based on a field in a table
There is an export parameter "QUERY", which lets you specify a WHERE clause for the select used by by the export command. It is documented in the Utilities guide.
When estimating the size of the export file, remember that the data volume exported per table is related to (average row length) *(number of rows), not the total allocated space for the table that you get from dba_segments.bytes or dba_tables.blocks*block_size. Index data volume count almost nothing towards your export file size
Last edited by slimdave; 11-08-2002 at 11:17 AM.
-
as per my past analysis details .
for if the databse is 70 GB dump file is usually 15GB . ( not checked index size ) and it takes around 2+ hours .
so for 200 GB it may take 45 GB dump size . and may take 6 hours on sunfire unix E15 K .
if it is NT , it may take very long time ..
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|