Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database directory Size and Memory Usage
When I run the export I receive the following error message:
EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name EXP-00000: Export terminated unsuccessfullyLast Message:The job failed.
Any help to resolve this would be appreciated.
Also, when I export each table what happens to any triggers, views, etc. that users have created. What tables do I not want to export.
jlr
"holders" <holders_at_demon.co.uk> wrote in message
news:39801EB2.107394CD_at_demon.co.uk...
Use MAXSIZE on tablespace and using ALTER DATABASE DATAFILE ....RESIZE to
try and decrease the size of the datafile.
SH
Steitz Adolf wrote:
Hi Jason,
have a look at your inital and next extents size of your tables.
Reduce the size-parameter, make an export, drop and recreate the tablespace,
and make an import.
Doing this, we reduced a data - tablespace from 8 to 3,6 GB and the index -
tablespace from 5,6 to 2,5 GB.
To limit the amount of disk space, put a limit on the maximum size of the
datafile(s) for the tablespace.
Adolf
Jason Rigsbee <jrigsbee_at_rigsbee.net> schrieb in im Newsbeitrag:
O5sK$o29$GA.64_at_cpmsnbbsa07...
> I have a database that has grown toooooo big for what it is and what it
> does. There is not much to this database (not many tables, views,
triggers,
> data, etc.) and it is used only for development purposes. It has grown to
> over 8GB in size. How can I shrink (compress) a database and then limit
the
> amount of disk space it can gobble up?
>
> Finally I also need to know how I can limit each database to a selected
> static memory space but preferably a dynamic range of memory-lets say
> between 0 MB and 150 MB of physical RAM when running?
>
> Thank you.
>
> jlr
>
>
Received on Thu Jul 27 2000 - 00:00:00 CDT