Re: Database 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 unsuccessfully

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

"Todd Measles" <measles8_at_swbell.net> wrote in message news:b0Nf5.594$Vh7.71781_at_nnrp2.sbc.net...
> You have to export the data one tablespace at a time, recreate the
> tablespace, then import the data back into the tablespace to get rid of
> extra free space. Check your documentation for import and export syntax.
> When creating your new tablespaces, you can specify maxsizes on your
> datafiles while autoextending is on, you must periodically check to make
> sure that the data files aren't filled up.
>
>
> You have to modify your init.ora file to change your memory configuration.
> This file is usually found in ORACLE_HOME\DATABASE or
> ORACLE_HOME\ADMIN\SID_NAME\PFILE directories. You can decrease the number
 of
> database_buffers, shared_pool_size and sort_memory_size parameters, but
 this
> might affect performance.
>
> Todd Measles
>
> "Jason Rigsbee" <jrigsbee_at_rigsbee.net> wrote in message
> news:OhTv#p29$GA.320_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 CEST