>RMAN Recovery -2

>create tablespace;

CREATE SMALLFILE TABLESPACE “EXAMPLE” DATAFILE ‘F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\example’ SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

CREATE SMALLFILE TABLESPACE “EXAMPLE” DATAFILE ‘F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\example’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
—————————-
create user;

CREATE USER “HR” PROFILE “DEFAULT” IDENTIFIED BY “*******” DEFAULT TABLESPACE “EXAMPLE” ACCOUNT UNLOCK
GRANT “CONNECT” TO “HR”
—————————-
create table;

CREATE TABLE “HR”.”TB_REHBER” ( “AD” VARCHAR2(20), “SOYAD” VARCHAR2(20))

Failed to commit: ORA-01950: no privileges on tablespace ‘EXAMPLE’

ALTER USER “HR” QUOTA UNLIMITED ON “EXAMPLE” –create etmek için

GRANT CREATE TABLE TO “HR”
GRANT ALTER TABLESPACE TO “HR”
DROP TABLE “HR”.”TB_REHBER” CASCADE CONSTRAINTS
REVOKE ALTER TABLESPACE FROM “HR”
REVOKE CREATE TABLE FROM “HR”

———————————

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s