8i user creation - data import

From: Richard Cuello <rc370_at_columbia.edu>
Date: Fri, 28 Jan 2000 12:02:54 -0500
Message-ID: <3891CBBE.38B39F45@columbia.edu>

Hi

I'm converting from Oracle 8 to Oracle 8i. I know how to create a user under Oracle 8:

---

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

---

SYSTEM
USERS
RBS
TEMP
OEM_REPOSITORY
INDX 6 rows selected.

SQL>

---

create user abc identified by xyz default tablespace user_data temporary tablespace temporary_data;

• How do you crate a user under Oracle 8i?
• Also, How do you do an import under 8i?

I usually enter this at the MSDOS prompt to import tables Oracle 8: IMP80 SYSTEM/MANAGER FROM USER=ABC TO USER=ABC FILE=1234.DMP LOG=1234.IMP.LOG Thanks Received on Fri Jan 28 2000 - 11:02:54 CST