AD

ORA-01219: database not open to allow only a fixed table / query attempt

alter database clear logfile group 3;
alter database open;
alter system switch logfile;
标签: logfile
分类: Database
时间: 2010-08-21

相关文章

  1. ORA-01219: database not open, only allow a fixed table / query attempt

    alter database clear logfile group 3; alter database open; alter system switch logfile;
  2. ORA-01219: database not open: only allow a fixed table / view queries

    Today, after running the oracle 10g in PLSQL Developer and Rapid SQL 7.6.0 after the connection using sys log ...
  3. Database is not open to allow only a fixed table. View query

    The problems encountered last night, "the database is not open to allow only a fixed table, view, query,& ...
  4. How quick access to oracle database records the number of rows in the table, do not use select count (1) mode

    Database Version: Oracle 10G Today, the database query a table under the specific number of records, the use o ...
  5. Access to all database users currently logged on and the corresponding table

    In the next mysql: / / Check all under the current logged in user database select SCHEMA_NAME from information ...
  6. Oracle Database 10g, the latest way to remove garbage table

    Frequent use of Oracle10g, we can find previously deleted table in the database there a lot more garbage table ...
  7. How to quickly access the oracle database records the number of rows in the table, do not use select count (1) way

    Database version: Oracle 10G Today, the database query in a table under the specific number of records, use se ...
  8. More than one database entity with another entity associated with a table issues - analysis of articles

    Recently encountered in the work of such a problem: multiple database entities (hereinafter referred to as &qu ...
  9. The Oracle database to simplify the management of a large table - partition table

    To simplify the large table in the Oracle database management, thus Oracle8 introduced the partition option. S ...
  10. Use database functions to split a string into a Table

    1, Oracle in Creating code: create or replace type t_SplitTable as object ( id integer, valueStr varchar2(8000 ...
  11. Database connection query

    Database connection Operators can achieve by connecting multiple table query. Connections are the main feature ...
  12. Introduction to MySQL notes

    In this book, because of the limited capacity of individuals to incur any error, if any, to facilitate the lat ...
  13. Oracle ora-01219 error solutions

    "ORA-01219: Database is not open : Allows only a fixed table / view queries " Warning window ! Login ...
  14. Common statement oracle database management

    1. Delete users and their users all the objects below drop user branch cascade; 2. Remove the table space and ...
  15. Oracle Database 10g Special Edition: Not only for beginners

    Analysis: Lewis Cunningham Oracle Database XE is not necessarily only for beginners, students, hobbyists or sm ...
  16. Oracle Database Backup and Recovery Summary -exp/imp (Export and Import Bank and unloading equipment library)

    sqlldr userid = B / A @ D control = result.ctl log = resulthis.out rows = 10000 bindsize = 8192000 1.1 Basic c ...
  17. orcale remotely connect to the database

    Configure your machine tnsname the remote database file name = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROT ...
  18. Database Replication

    A few days ago, boss let me play with the database, Anjiu not seriously played this thing. Boss said do not wo ...
  19. Oracle Database Backup (exp / imp command)

    -------------------------------------------------- ------------------------------------- Oracle Database Backu ...