Create temporary in tablespace database username _temp
Tempfile as expected 'D: \ \ 12959 \ oradata \ app wouldn \ database user name _temp DBF'
The size of 50 m
Autoextend on
Next 50 m maxsize 20480 m
Among management, local;
The DROP in TABLESPACE ekp o CONTENTS AND DATAFILES.


The create in tablespace database user name
Logging
Datafile 'D: \ app \ 12959 \ oradata \ wouldn \ database user name. DBF'
The size of 50 m
Autoextend on
Next 50 m maxsize 20480 m
Among management, local;


The create user database username identified by password
The default username in tablespace database
Temporary in tablespace database username _temp;


Grant connect, the resource, the dba to database user name;

CodePudding user response:

Your problem?

CodePudding user response:

So, your question?

CodePudding user response:

This should be a knowledge accumulation of posts,

The original poster can record the knowledge, in a blog post, after looking for easier, the

CodePudding user response:

This is knowledge sharing

CodePudding user response:

CodePudding user response:

Thought is what problem, the original is the knowledge sharing, writes on his blog well