Tag Info

Hot answers tagged

6

In Oracle deleting rows from a table won't automatically release any disk space. It is possible to release disk space but to accomplish this you have to find out how the tables are physically placed in the datafiles. As soon as a datafile has empty blocks on the end, you can resize the datafile to a smaller size. Only after this - successful - operation you ...


4

In Oracle, as of version 11.2, you can't rename a schema (=user). See this discussion on AskTom for a workaround: you would export the user, reimport with the good name (using FROMUSER and TOUSER). All references (if any) in pl/sql code will have to be updated manually. Grants and public synonyms will have to be recreated separately.


3

There are choices here. Check out the Oracle Documentation Upgrade Guide for more info.


3

It looks like these are the archived version of the redo log. The archived log are used when you restored your database and want to recover the changes made after the backup you used to recover. (the following commands are for Oracle 10g & 11g. They might have changed since 9i) If you backup your database using RMAN, you can include the archived log ...


3

Make a backup and restore it to your new Pc and make backups in the future!


2

You can use restricted mode to keep everyone off who does not have RESTRICTED_SESSION privileges: ALTER SYSTEM ENABLE RESTRICTED SESSION; This does not prevent other users with this privilege from logging on.


2

IDENTIFIED EXTERNALLY is used for OS authentication IDENTIFIED GLOBALLY is used for OID authentication(also known as EUS) Both of these mean that password management is done outside the database.


2

You can download it from Oracle; here is the product page.


2

It's a static parameter so it needs to be changed in the pfile / spfile and then the instance restarted.


1

Did something change on the network ? Was a firewall added on the path between client and oracle server ? Posting the database ora config file would help


1

We've found Oracle 9i to behave pretty well on Server 2003. We've patched both 8i an 9i to higher versions on a 2003 server and all patches went off without a hitch. Having said that though, always make sure you FULLY READ Oracle's patch instructions and readme's because they really like to hide gotchas in there.


1

It looks like your export statement is valid but I have seen this when trying to mix/match export/import versions and databases. Are you using the export binaries that go with the version of the database you are using? If you just type 'exp' it will tell you the version. The version of your exp.exe should be the same as the database version you are ...


1

If you have access to metalink - document 136697.1 has a healthcheck script.


1

I think the most important part of the health check is not the data extraction, but data analysis. We have our scripts built around statspacks, as they provide most reliable results and statistics. http://www.leaderside.com/oracle-health-check/oracle-healthcheck-2 Learn more here.


1

Check out this SF question.


1

The exact way, could depend on your configuration, but roughly, you could: 1) Export / Import (see documentation for exp) 2) Cold backup: Make sure you have a copy of your pfile/spfile Shutdown your source database Copy your datafiles to the new server There are some steps to do in between, but the advice is to consult with an oracle DBA, or read the ...


1

How big is your data and how many schemas? Doing the export/import can be a lot faster for smaller databases and gives you a chance to cleanup old users and re-organize tablespaces. It's not very practical for a large database like an E-Business Suite install although I had to do that once because I was going from big-endian to little-endian hardware.


1

You might want to look at this thread: Porting an application from Oracle 9 to Oracle 11 - gottchas?


1

To complete other answers, purging diag logs can help you free some significant disk space (up to several GBs). Check this : http://www.databasejournal.com/features/oracle/article.php/3875896/Purging-Oracle-Databases-Alert-Log-with-ADRCI---Usage-and-Warning.htm Basically, you will run the adrci Oracle command line utility, then do: adrci> set homepath ...



Only top voted, non community-wiki answers of a minimum length are eligible