Re: Database Size and Memory Usage

Make sure your ORACLE_SID is pointing to the correct database. In case you don't want to change the SID then use loginid_at_SIDNAME. Also make sure that the tnsnames.ora file contains the SID details from which you are trying to export.
Hope this helps.
Try the command tnsping SIDNAME. This will tell you whether you are able to ping the database or not.

On Thu, 27 Jul 2000 11:13:54 -0400, "Jason Rigsbee" <jrigsbee_at_rigsbee.net> wrote:

>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
>Last 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
>
>
>"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 Aug 10 2000 - 00:00:00 CEST