Re: how to know target and source db size in 9i

Comments embedded.
chijar wrote:
Dear friends.
This is an hypothetical case:

Certainly it is. And I have antlers.

i have received a file.dmp and file.log from a database production.

That's ... nice ...

i have to restore this dmp in another database in a test environment.

And you're the first to do this type of task?

You know only that the source database (production) is more big than
the target database (test).

Uh-huh. Sounds like someone needs some instruction with regard to
proper and complete communication.

- how to know the size of target database?

You HAVE access to the target else you can't import the
tables/data/objects. So, query dba_data_files so that you KNOW how
much space you have allocated, then query dba_free_space to see how
much space you have AVAILABLE. It is truly that simple.

- how to know the size of source database? if i dont have any kind of
access to production environment? in order to the restore operation
will be ok.

You ASK the production DBA how large the production database is. He or
she has acces to it.


The import utility give any command to know that?


No. Why on earth would it? You could, if you had enough drive,
ambition and desire, read the documentation on imp and exp and you'd
discover that:

-- you can, using imp, generate an indexfile from a .dmp file, showing
all create table/create index statements and the initial settings for
extent sizes.

-- you could then sum these sizes, by tablespace, to obtain a rough
estimate of the initial size required to create the obects. This, of
course, requires more than a passing familiarity with grep and awk.

This still wouldn't provide total size data for the source database,
but that's why you ask the production DBA such things. And I know you
can ask questions; you posted this in hopes of receiving a quick
'how-to' guide. Hope springs eternal.

Both environment is Release 9.2.0.1.0 and SO is UNIX


Both environments need to be patched to at LEAST 9.2.0.6. And that
doesn't change my responses.

tks

For what? You *expect* people to cater to your laziness, and laziness
it is as illustrated by your 'abbreviations'. Have you lifted a finger
to actually do your own research? Spoon-feeding is not a practice of
this newsgroup, so stop thinking someone here will do that for you.
Look these things up at http://tahiti.oracle.com. Stop being a slug.


David Fitzjarrell

.