Hot answers tagged oracle9i
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 ...
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.
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.
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 ...
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 ...
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.
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 ...
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.
Only top voted, non community-wiki answers of a minimum length are eligible