grant drop database link to user in oracle

installation of Oracle database :One:Install the time can be set to unlock the user generally by default is to unlock SOCTT users and HR users;Oracle's Super User is SYSDBA This user can also set a password when installing, aYou can set the password directly when you use it,

This article introduces some common statements used to import and export tablespaces in oracle 11g linux. For more information, see. Sqlplus /As sysdba -- View the dbf storage locationSelect * from dba_data_files; -- view the file location SELECT * FROM dba_directories;-- Create a tablespaceCreate tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf' size 100 m autoextend on next 50 m maxsize 200 m extent management local;-- Create

Data backup and Database Replication in Oracle user management mode The first thing to note is that Oracle Database Backup can be divided into logical backup and physical backup. Logical backup backs up data through data export, mainly through the old IMP/EXP and Data Pump l

Oracle user creation and database backup and restoration operations -- Create the user create user XX identified by "" default tablespace USERS temporary tablespace TEMP profile DEFAULT password expire; -- Grant/Revoke role privil

Label:database_idsnippetwhereora base data trackingswitch --Create the user create user XX identified by "", default tablespace USERS temporary tablespace TEMP profile DEF Ault password expire; --Grant/revoke role privileges Grant connect to Xx Oracle Create

Oracle database use process, for the system will establish a separate database users, but some time in the test or other reasons need to delete, the original DB users, then we can use the following method.The premise of the subordinate operation is to ensure that the database service and monitoring are in the boot stat

Label:View the number of connections to the Oracle database and the user11. Query the number of connections to Oracle2select Count (*) from v$session;32. Querying the number of concurrent connections for Oracle4select Count (*) from v$session where status= ' ACTIVE ';53. View the number of connections for different users6select Username,count (username) from V$session where username are not null GROUP by us

database has a system tablespace that is created automatically during database creation or database installation, data dictionary tables for storage systems, program system units, process functions, packages, and triggers, and can also be used to store user data tables and indexed objects. Tablespaces have online and

* * Start * *1, start the database instance, is divided into two steps: The first step, starts listens; the second step is to start the database instance. 1.1 Go to Sqlplus startup instance{{{[Oracle@redhat ~]$ su-oracle--"Switch to Oracle

the latest transaction processing. The restored block is generated throughout the process. This is called roll-forward or cache restoration. 3. At this time, the restored data file contains submitted and uncommitted changes. 4. Restore blocks are used to roll back any uncommitted changes. It is also called transaction recovery. 5. At this time, the data file is in the restored State and consistent with other data files in the database. --------------

Before Oracle 10 Gb, when we connect to the database in SHELL or JDBC, we need to enter the user name and password, and both are in plain text. Starting from 1OGR2, ORACLE provides the wallet tool to log on to the database without entering the

Sqlplus /as SYSDBA --View DBF storage locationSELECT * from Dba_data_files; --View File location SELECT * from Dba_directories;--New Table spaceCreate tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf ' size 100m autoextend on next 50m maxsize 2 00m extent management Local;--New userCreate user bp_oracle identified by bp_oracle default Tablespace bp_oracle;--User AuthorizationGrant C

0Job_queue_processes Integer 10Log_archive_max_processes Integer 2Processes integer 450Sql>Concurrency refers to active,i seeSql> Select COUNT (*) from V$session #连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Show parameter Processes #最大连接Sql> alter system SET processes = value scope = spfile; Restart database #修改连接Unix 1 user session corresponds to an operating system process

Error: [Oracle@www.bkjia.com data] $ exp "sys/oracle@www.bkjia.com as sysdba" file =/data/sys. dmp log =/data/sys. log full = y;LRM-00108: invalid positional parameter value 'as' EXP-00019: failed to process parameters, type 'exp HELP = y' for helpEXP-00000: Export terminated unsuccessfully Cause:This may be a BUG of Oracle10g. You only need to follow the following two methods: Solution: Method 1:[

/* divided into four steps *//* Step 1th: Create a temporary tablespace */Create temporary tablespace kmyf_tempTempfile' E:\app\pangxy\product\11.2.0\dbhome_1\kmyf_temp.dbf ' size 50m autoextend onNext 50m maxsize 20480m extent management local;/* Step 2nd: Create a data table space */Create tablespace kmyf_data LoggingDataFile ' E:\app\pangxy\product\11.2.0\dbhome_1\kmyf_data.dbf ' size 50m autoextend onNext 50m maxsize 20480m extent management local;/* 3rd step: Create

If you want to install the sample user in Oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also create a database after installing the database software database.The original storage location of the sample file in linux: $ ORACLE_HO

Win+r Investigation Run window, enter CMD returnConnect to a local Oracle libraryCreate a tablespace named "SXSJ" with an initial size of 512M and support auto-scaling with 32M increments per increment;Create tablespace sxsj datafile ' D:\app\LZB\oradata\SXSJ ' size 512M autoextend on next 32M;Create a user named "SXSJ"CREATE USER SXSJ identified by SXSJ DEFAULT

Create an oracle database, user, tablespace, and role permission setting script/* Divided into four steps *//* Step 2: create a temporary tablespace */Create temporary tablespace contract_tempTempfile 'd: \ oradata \ contract_temp.dbf'Size 50 mAutoextend onNext 50 m maxsize 20480 mExtent management local;/* Step 2: create a data table space */Create tablespace co

Label:/* divided into four steps *//* Step 1th: Create a temporary tablespace */Create temporary tablespace contract_tempTempfile ' D:\oradata\contract_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* Step 2nd: Create a data table space */Create Tablespace Contract_dataLoggingDataFile ' D:\oradata\contract_data.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* 3rd step: Create user and specify

/* Step 2: Log On */log on to PL/SQL with sys/sys Super User/* Step 2: create a temporary tablespace */create temporary tablespace user_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ Wu \ user_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 M extent management local;/* Step 4: create a data table space */create tablespace user_data logging datafile 'e: \