Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving a database from 8.0.5 to 8.1.7
Bruno Jargot <see_at_reply.to.invalid> wrote:
: On 30 Aug 2001 16:43:53 GMT, Christoph Kukulies wrote:
:>Galen Boyer <galenboyer_at_hotpop.com> wrote:
:>: On Thu, 30 Aug 2001, postbus_at_sybrandb.demon.nl wrote:
:>
:>: Chris,
:>
:>: I think I would use exp/imp for this, but you might have really
:>
:>
:>When using at the command line:
:>
:>exp80 system/manager file=x log=x full=y
I found that I got to do
exp80 sys/<passwd>@database file=x log=y full=y
to address the database/instance I want to export.
What would be taken if I omit @database?
:>It's just 8 MB and that's it.
:>Looking into \orant\databases I see
:>SYS1ORC0.ORA 80 MB
:>SYS1ORC1.ORA 80 MB
:>SYS1ORC2.ORA 114 MB
:>
:>TMP1...
:>
:>USR1..
:>
:>lots lots more
: The dump file contains only the user data. It doesn't contain the : rollback segment, the dictionnary, the indexes, the temp (only the : sql commands for create them) : The size of the datafiles doesn't necessairly reflect the real size of : the data. The datafiles can be empty, the allocated space for segments: can be empty too. I've seen (every days in fact ...) a database which : have 4 GB of datafiles but only 300MB of real data.
: If you don"t have any error in the log file of the export then your : database is full of void ...
-- Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.deReceived on Mon Sep 03 2001 - 09:38:13 CDT