.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

<< < … 134 135 136 137 138 139 140 141 142 143 144 … > >>   Sort: Rank

How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you ho... 2007-05-02, 5253👍, 0💬

What Are the Original Export and Import Utilities
What Are the Original Export and Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with differen... 2007-05-02, 5965👍, 0💬

How To Change User Password
How To Change User Password? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL>... 2007-05-02, 5460👍, 0💬

How To Delete a User Account
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fy... 2007-05-02, 7959👍, 0💬

How To Import One Table Back from a Dump File
How To Import One Table Back from a Dump File? - Oracle DBA FAQ - Loading and Exporting Data If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import th... 2007-05-02, 5659👍, 0💬

What Privilege Is Needed for a User to Connect to Oracle Server
What Privilege Is Needed for a User to Connect to Oracle Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: >.\bin\sq... 2007-05-02, 5415👍, 0💬

What Happens If the Imported Table Already Exists
What Happens If the Imported Table Already Exists? - Oracle DBA FAQ - Loading and Exporting Data If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: >cd \oraclexe\ap... 2007-05-02, 5143👍, 0💬

How To Grant CREATE SESSION Privilege to a User
How To Grant CREATE SESSION Privilege to a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the ser... 2007-05-02, 5246👍, 0💬

How To Revoke CREATE SESSION Privilege from a User
How To Revoke CREATE SESSION Privilege from a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fy... 2007-05-01, 5542👍, 0💬

How To Export Several Tables Together
How To Export Several Tables Together? - Oracle DBA FAQ - Loading and Exporting Data If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise: >cd \oraclexe\app\o... 2007-05-01, 5214👍, 0💬

How To Export Your Own Schema
How To Export Your Own Schema? - Oracle DBA FAQ - Loading and Exporting Data If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system... 2007-05-01, 5519👍, 0💬

How To Lock and Unlock a User Account
How To Lock and Unlock a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command... 2007-05-01, 5691👍, 0💬

How To Do a Full Database Export
How To Do a Full Database Export? - Oracle DBA FAQ - Loading and Exporting Data If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXP... 2007-05-01, 5449👍, 0💬

What Privilege Is Needed for a User to Create Tables
What Privilege Is Needed for a User to Create Tables? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges To be able to create tables in a user's own schema, the user needs to have the CREATE TABLE privilege, or the CREATE ANY TABLE privilege, which is more powerful, and allows t... 2007-05-01, 5166👍, 0💬

Where Is the Export Dump File Located
Where Is the Export Dump File Located? - Oracle DBA FAQ - Loading and Exporting Data If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump... 2007-05-01, 5632👍, 0💬

How To Assign a Tablespace to a Users
How To Assign a Tablespace to a Users? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges When you create a new user, Oracle will assign the SYSTEM tablespace to the user by default. If you want to change this, you can assign a different table space to a user using the ALTER USE... 2007-05-01, 5400👍, 0💬

What Privilege Is Needed for a User to Create Views
What Privilege Is Needed for a User to Create Views? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges To be able to create views in a user's own schema, the user needs to have the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful, and allows the u... 2007-05-01, 5181👍, 0💬

How To Estimate Disk Space Needed for an Export Job
How To Estimate Disk Space Needed for an Export Job? - Oracle DBA FAQ - Loading and Exporting Data If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you ... 2007-05-01, 6449👍, 0💬

What Are Data Pump Export and Import Modes
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes: Full: Exports and imports a full database. U... 2007-05-01, 8114👍, 0💬

What Privilege Is Needed for a User to Create Indexes
What Privilege Is Needed for a User to Create Indexes? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise g... 2007-05-01, 5146👍, 0💬

What Privilege Is Needed for a User to Query Tables in Another Schema
What Privilege Is Needed for a User to Query Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercis... 2007-05-01, 5522👍, 0💬

What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives y... 2007-05-01, 5187👍, 0💬

How To Invoke the Data Pump Import Utitlity
How To Invoke the Data Pump Import Utitlity? - Oracle DBA FAQ - Loading and Exporting Data The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. H... 2007-05-01, 5690👍, 0💬

How To Invoke the Data Pump Export Utility
How To Invoke the Data Pump Export Utility? - Oracle DBA FAQ - Loading and Exporting Data The Data Pump Export utility is distributed as executable file called "expdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "expdp" command. He... 2007-05-01, 6010👍, 0💬

<< < … 134 135 136 137 138 139 140 141 142 143 144 … > >>   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