sqlplus show tables in schema

Sqlplus provides many common commands. The following describes how to use them. 1-> sqlplus login and exit Sqlplus-H |-v-H displays the version and help information of sqlplus, and-V displays the login Syntax of its version information: Is :

Oracle Note (ii) sqlplus commandFor Oracle database operations, the command line is used primarily, and all commands are done using sqlplus, and there are two forms for sqlplus. One is the sqlplus:sqlplus.exe of DOS style; The other is

I. Startup and shutdown of Oracle1, in a single-machine environment2, in the dual-machine environmentIi. What kinds of startup methods are available for Oracle database?1, startup Nomount non-installation start, this way startup executable: Rebuild

From http://baike.baidu.com/view/1239908.htm SQL * Plus is one of the most commonly used tools with strong functions, mainly including: 1. database maintenance, such as startup and shutdown, is generally performed on the server.2. Execute SQL

I. Startup and shutdown of Oracle1, in a single-machine environmentTo start or shut down an Oracle system, you must first switch to an Oracle user, as followsSu-oracleA. Start the Oracle systemOracle>svrmgrlSvrmgr>connect

When Oracle 11g is exported using EXP, empty tables cannot be exported, and 11 gexp I. cause:There is a new feature in 11G. When the table has no data, no segment is allocated to save space.1. insert a row and then roll back to generate a

Second, SQL structur Query Language Structured Query language, is the object in the Operation relational database.DDL (data definition Language), used to create or delete table operations, and to modify table constraints CREATE TABLE, ALTER TABLE,

A. Question:How to implement a user name that does not need to be added to a table when accessing other users ' tables in the Oracle databaseTwo. For example:User A in Oracle needs to access User B's table with a prefix of User B, such as access to

ORACLEprimary system tables and system views 1.system Tables ORACLEthe system parameters of the database are stored in the database and can beSQLPLUS, to the userSYSto query. A few important tables or views are as follows:V$controlfile: Control the

Body: 1, oracle11g default to Empty table is not assigned segment, so use EXP export oracle11g database, empty table is not exported. 2. After setting the Deferred_segment_creation parameter to False, both the empty table and the non-empty table