Examples of Oracle-related operations (export import DMP required)

Delete users: Drop user pnxd cascade;

Export DATA: Exp pnxd/[email protected] file=c:\bb.dmp full=y

Import data: Imp pnxd/[email protected] file=c:\bb.dmp ignore=y full=y

Created by: Create user pnxd identified by padmin

Assign permissions: Grant Connect,resource to Pnxd
Grant Dba:grant DBA to Pnxd

Rebuilding permissions for importing new databases

CREATE TABLE Space

CREATE tablespace p2p_nxd
LOGGING
DataFile ' D:\app\Stephen\product\11.2.0\dbhome_1\P2PNXD. DBF '
SIZE 32M
Autoextend on
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

Create a sequence

Create sequence sequence name
MinValue 1maxvalue 99999999start with 1increment by 1
The sequence name. Nextval get a unique number

Create sequence T_sys_roles_seq
MinValue 1 MaxValue 999999999 start with 1 increment by 1

Examples of Oracle-related operations (export import DMP required)