.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 2 3 4 5 6 7 8 9 10 11 12 … > >>   Sort: Rank

How To Rename a Column in an Existing Table
How To Rename a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statem... 2007-05-03, 5374👍, 0💬

How To Create a new Oracle Data File
How To Create a new Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database. 2007-05-03, 4937👍, 0💬

How To Add a New Column to an Existing Table with a Default Value
How To Add a New Column to an Existing Table with a Default Value? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to add a new column to an existing table, and insert a default value in this column on all existing data rows, you can use the ALTER TABLE ... ADD statement with the DEFA... 2007-05-03, 5088👍, 0💬

How To View the Data Files in the Current Database
How To View the Data Files in the Current Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL> connect SYSTEM... 2007-05-03, 5052👍, 0💬

How To Add a New Column to an Existing Table
How To Add a New Column to an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL> connect HR/fyi... 2007-05-03, 5308👍, 0💬

How To Rename a Tablespace
How To Rename a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files You can easily rename a tablespace by using the ALTER TABLESPACE ... RENAME TO statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace creat... 2007-05-03, 5079👍, 0💬

How To Drop an Existing Table
How To Drop an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to delete an existing table and its data rows, you can use the DROP TABLE statement as shown in this script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees W... 2007-05-03, 5135👍, 0💬

How To Create a New Tablespace
How To Create a New Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want a new dataspace, you can use the CREATE TABLESPACE ... DATAFILE statement as shown in the following script: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace c... 2007-05-03, 5058👍, 0💬

How To Rename an Existing Table
How To Rename an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you don't like the name of an existing table, you change it by using the CREATE TABLE ... RENAME TO statement. Here is a sample script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELEC... 2007-05-03, 5517👍, 0💬

How To Drop a Tablespace
How To Drop a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you have an existing tablespace and you don't want it anymore. You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/tem... 2007-05-03, 4974👍, 0💬

How To Create a New Table by Selecting Rows from Another Table
How To Create a New Table by Selecting Rows from Another Table? - Oracle DBA FAQ - Managing Oracle Database Tables Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the CREATE TABLE...AS SELECT statement to... 2007-05-03, 5354👍, 0💬

What Happens to the Data Files If a Tablespace Is Dropped
What Happens to the Data Files If a Tablespace Is Dropped? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you... 2007-05-03, 5164👍, 0💬

How To Create a New Table in Your Schema
How To Create a New Table in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: >.\bin\sqlplus /... 2007-05-03, 5595👍, 0💬

How To Create a Table in a Specific Tablespace
How To Create a Table in a Specific Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLES... 2007-05-03, 5028👍, 0💬

How To See Free Space of Each Tablespace
How To See Free Space of Each Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free... 2007-05-03, 5019👍, 0💬

What Is a Database Table
What Is a Database Table? - Oracle DBA FAQ - Managing Oracle Database Tables A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a colum... 2007-05-03, 5244👍, 0💬

How To Bring a Tablespace Offline
How To Bring a Tablespace Offline? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL> connect HR/fyicenter Connected. SQL> CREATE ... 2007-05-03, 4924👍, 0💬

How To Bring a Tablespace Online
How To Bring a Tablespace Online? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL> connect HR/fyicente... 2007-05-03, 5481👍, 0💬

How To Add Another Datafile to a Tablespace
How To Add Another Datafile to a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you created a tablespace with a data file a month ago, now 80% of the data file is used, you should add another data file to the tablespace. This can be done by using the ALTER TABLESPACE ..... 2007-05-03, 5211👍, 0💬

What Happens If You Lost a Data File
What Happens If You Lost a Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files After you shuting down an Oracle database, you accidently deleted a data file from the operating system. If you try to start the database again you will get error when Oracle tries to open the databas... 2007-05-03, 6372👍, 0💬

What Happens to the Indexes If a Table Is Recovered
What Happens to the Indexes If a Table Is Recovered? - Oracle DBA FAQ - Managing Oracle Table Indexes If you dropped a table, and recovered it back from the recycle bin, what happens to its indexes? Are all indexes recovered back automatically? The answer is that all indexes will be recovered, if yo... 2007-05-03, 5811👍, 0💬

How Remove Data Files befor opening a Database
How Remove Data Files befor opening a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline befor o... 2007-05-02, 5071👍, 0💬

What Is a User Account
What Is a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects De... 2007-05-02, 4962👍, 0💬

How To Recover a Dropped Index
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have the recycle bin feature turned on, dropped indexes are stored in the recycle bin. But it seems to be command to restore a dropped index out of the recycle bin. FLASHBACK INDEX is not a valid statement. See t... 2007-05-02, 8329👍, 0💬

<< < … 2 3 4 5 6 7 8 9 10 11 12 … > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML