IMP Import Database hints tablespace not found problem.

Database installed, the default use of things OMCL, get the test database, with Plsql import, prompt 1 seconds to complete, it is obviously unsuccessful. Then use IMP import, the result hint tablespace omc8 not found, so delete omcl database, rebuild OMC8 database, see if you can succeed ...

A long wait ....

Let's talk about Oracle's knowledge:

The previous contacts were primarily Sybase, and were all relatively low-level things. Learn Oracle these days and have a preliminary understanding of it.

Oracle's management of permissions is perfect. There is also the data management is more flexible, such as can expand the table space, and then the database file can be more flexible to store.

For an OS-only system (Linux) to build a complete Oracle platform, the following actions are required:

2. Create users and groups for Oracle

4. Create an Oracle installation directory

6. Set the environment variables for Oracle under/home/oracle/.bash_profile.

8. Unzip the installation file

10. Query the required installation package is complete, if not complete, to install.

12. Modify Linux kernel parameters. /etc/sysctl.conf

14. Set Shell limits for Oracle users.

16. Setting the host name and IP,IP is basically the IP address of the native computer.

18. Set the Oracle support RHEL5 parameter.

20. Oracle user installation files, followed by some graphical things, basically is the next step, it is important to note that the choice of path. And there's a place to start.

22. Create a database. Create with DBCA, prevent garbled, first unset LANG. Then the next step is to note that the maximum number of connections 150 is changed to 1500, and then the font is set to Simplified Chinese.

24. Verify that the installation is successful.

26. Configure monitoring.

Long wait to finish, after installing OMC8 database, startup prompt could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/**. It is possible that the environment variable was set up before the problem. Helpless Delete omc8, reinstall OMCL, again consider other methods.

(not finished)

IMP Import Database hints tablespace not found problem.