Creating Oracle User On Development Instance

Jul 25, 2013

I have been asked to improve the speed of our extract feeds to another team. It was using an excel file as csv created with C# reading the csv into a global temporary table and a procedure to insert rows from global table to main table one at a time.

Around 1 million rows That was taking around 25 min. After trying sqlldr and an intermediate table I managed to reduce timing to 15 sec with sqlldr and Direct Path Load. I tried all that in one of our own DEV databases. Now we want to try the approach in one of DEV databases belong to downstream group (the one we feed data). They are rather reluctant to give me access to their DEV database! I have asked them to create a new login and grant object creation (DDL) to this user.They keep saying that they are prepared to give me a role but NOT schema owner. What is the best way of enabling me to create tables somewhere and test loading times with sqlldr.

I need to do full DDL (table/proc creation) and DML on a certain schema. So my question: What is the best way of doing so.. Do I need a schema created for user to do this workI they already have a general purpose schema, can they create a role to have full DDL: rights in that schema? 

View 6 Replies


ADVERTISEMENT

SQL & PL/SQL :: Structure Schemas Within Single Oracle Instance To Support Multiple Project Development

Jan 24, 2013

The best way to structure my schemas within a single Oracle instance to support multiple project development. At the moment, within an Oracle instance I have Area_Dev and Area1_Test schemas, with the intention that Project Xv1.0 would use Dev schema for development and Test schema for testing.

Lets say I want to start on Project Xv2.0 development while I am still finalizing Project Xv.10 development what is the best way of accommodating that, without creating individual schemas for each project?

View 3 Replies View Related

Forms :: Creating Domain Failed While Configuring Oracle Instance?

Feb 14, 2013

I have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.

(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)

Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.

View 2 Replies View Related

Creating User On Oracle AIX To Never Expire

Dec 8, 2010

I need to create a user on oracle aix to never expire. I did the following

create user identified by password
grand dba to user
alter user password_life_time unlimited

is this all i need to do?

View 1 Replies View Related

SQL & PL/SQL :: Creating User Groups In Oracle 10g?

Mar 14, 2012

i want to create a group xyz and add some users to xyz group and want to grant/revoke permissions to xyz. So that all the users present in that group will have the same permissions as of the xyz group. so that instead of giving the permissions to users individually i can give it at a time.

View 20 Replies View Related

Creating ASM Instance?

Feb 7, 2011

creating an ASM instance. I've never done this before and searched all known documentation. I just can't seem to figure this out. This is an 11g database on a WinXp machine for testing purpose before attempting to do this on a live production environment

D:\app\user\product\11.1.0\db_1\BIN>localconfig add

Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'Dummy\user', privgrp '
Operation successful.

Step 2: creating new CSS service
Failed to create the new CSS service, err(5)
failed to create CSS services

View 6 Replies View Related

Server Administration :: Creating A View In User From Another User?

Nov 9, 2011

I have a strange problem when creating a view in user from another user

I have a user called "Cash_tst"

its syntax creation is

-- Create the user
create user CASH_TST
identified by ""
default tablespace CASH
temporary tablespace TEMP
profile DEFAULT
quota unlimited on cash;
-- Grant/Revoke object privileges
grant connect to CASH_TST;
grant dba to CASH_TST;
grant resource to CASH_TST;

-- Grant/Revoke system privileges
grant create any view to CASH_TST;
grant unlimited tablespace to CASH_TST;

I want to create a view

CREATE VIEW TAMER
AS SELECT *
FROM [b]AROFL[/b].RA_CUSTOMER_TRX_LINES_ALL_BEFO

"AROFL" is another user on the same database
when try to create the view "tamer" i got message of
"insufficent privilege"
although i granted "create any view" to the user "cash_tst"

View 12 Replies View Related

SQL & PL/SQL :: Creating New Instance Compared To New Schema?

May 17, 2011

I have SQL Server database I would like to migrate into Oracle. The database supports a large application. It is around 10GB. I requested a new instance but was advised I would have to pay for that but if I asked for a new Schema it could go in our current company instance. I am fine with that since it wont cost more money if I just add a new schema to our Company Oracle instance. Just curious what is the advantage of getting a new instance compared to creating a new schema for 10 GB of data?I assume the advantage of creating a new instance is our Schema (in new instance) and work will have its own space/house and can grow in size without any issues?

View 3 Replies View Related

PL/SQL :: Error While Creating View From One Instance To Another?

Aug 22, 2012

H want to Create a view which reside in one instance for example xxx Instance . I want to create the same view which reside in xxx instance to another instance for example YYY Instance How to acheive this ?I tried desc the View take the view script from XXX instance and copied the view script to YYY instance when I compiled Iam getting an Error

For Example My view in XXX Instance
CREATE OR REPLACE FORCE VIEW xxx.sample
(
First_name,
last_name
)
as
     select "F_NAME",
             "L_NAME"
     FROM  EMP;

When try to copy and compile the same view in my YYY Instance i am getting error

View 7 Replies View Related

Server Administration :: Creating ASM Instance Using DBCA / ORA-01012 Not Logged On

Jul 14, 2010

create an ASM (Automatic Storage Management) instance using dbca. At first try I mistakenly skipped the part where I click on ASM Parameters to add /dev/raw/raw* as my asm_diskstring so it created an ASM instance. When I get to the next page ASM Disk Groups, I selected Create New and I did not have the desired display, because of the step I missed.

I went back to do some cleaning up as follows:

1) Edit the oratab file to remove the ASM entry

2) backed up these files by renaming to old-<filename>
old-ab_+ASM.dat
old-hc_+ASM.dat
old-lk+ASM
old-orapw+ASM
old-spfile2+ASM.ora

3) killed the following processes (kill -9):

oracle 1590 1 0 22:52 ? 00:00:00 asm_pmon_+ASM
oracle 1592 1 0 22:52 ? 00:00:00 asm_psp0_+ASM
oracle 1594 1 0 22:52 ? 00:00:00 asm_mman_+ASM
oracle 1596 1 0 22:52 ? 00:00:00 asm_dbw0_+ASM
oracle 1598 1 0 22:52 ? 00:00:00 asm_lgwr_+ASM

[code]....

4) Run the following as root:

/u01/app/oracle/product/10.2.0/db_1/bin/localconfig delete

5) Restarted the database

Now when I try to go through the steps to create an ASM instance, at the point after I enter my ASM Parameters, I get the following prompt:

"DBCA will now create and start the ASM instance. After the ASM instance is started you can create the diskgroups to be used as storage for your database."

I click OK. Then I get the error message:

ORA-01012 not logged on

View 12 Replies View Related

Web Application Development With Oracle

Sep 25, 2003

I have designed a web application that has the basic functions of an e-commerce shopping cart site. I have been using the combination of php, and mysql.

However over time I have noticed shortcomings and would like to now migrate to oracle for future sites as my database. PHP is a great language, but I am wondering what Language would be EASIEST to migrate to and works BEST with oracle.

View 11 Replies View Related

To Know User Already Exist Or Not In ASM Instance (11g )

Nov 25, 2010

In Oracle11g (R1 and R2) we can create the user in +ASM instance just like normal oracle database. But If the user already exist I get an error

CREATE USER test IDENTIFIED BY test
*
ERROR at line 1:
ORA-01920: user name 'TEST' conflicts with another user or role name

So, I would like to know if there is any data dictionary view which can tell me if the user already exist or not.

View 5 Replies View Related

How To Find Form Development Tool In Oracle 9i

Jan 23, 2013

How to find the oracle form development tool in oracle 9i?

View 1 Replies View Related

Server Administration :: To Configure New ASM Instance As Root User

Mar 2, 2013

I am trying to configure a new ASM instance. I am getting error " -bash: crsctl: command not found" .. where should i actually look for the error. crsctl command not found.... I am doing this as a root user .

View 5 Replies View Related

Backup & Recovery :: Create Another Instance For Catalog User To Import It

Jan 13, 2013

On production server i have the production database and i have another instance for recovery catalog database.and on DR server i have only one instance for production database .In the scenario of recovery,

- i did export for recovery catalog user
- i have latest rman backup for production database

On the DR server as i mention up , i have only on instance , my question is , i need to create another instance for recovery catalog user to import it ? or on the same target database on DR i can import the recovery catalog ?

View 3 Replies View Related

Creating A User Through Forms 6i?

Sep 12, 2010

I created a form that would allow a user to create another user.i tried creating a user in forms 6i using the following code on the when button pressed:

BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;

pasword and user_name are captured in the form.

View 2 Replies View Related

Creating User To Do A Delete From All Tables

Oct 30, 2011

I am trying to create a new user who will be able to do a delete from all of the tables that only I MYSELF created. I created my user and granted access but realized I may not have done it right..

is it simply SQL>grant delete on <TABLESPACE> to <new user>; ? or do i need to specify the grant the delete on my tablespace to new user?

View 4 Replies View Related

SQL & PL/SQL :: Creating New User - How To Encrypt Data

Jun 15, 2010

We are using oracle forms 6i as front end and oracle 10g as back end.When we are creating a new user, the password should be stored in back end table in encrypted format.

View 4 Replies View Related

How To Use User Defined Type While Creating New Table

Oct 13, 2009

That is I have created the User Defined Data Type as following. CREATE OR REPLACE TYPE Bit_Type AS OBJECT(Bit NUMBER(1,0));

After completing this creation of new UDT, I am trying to create the table with this UDT as follows, CREATE OR REPLACE TABLE Sample_Bit ( RegID Bit_Type);

I received an Error Message like:
SQL Error: ORA-22913: must specify table name for nested table column or attribute
22913. 00000 - "must specify table name for nested table column or attribute"
*Cause: The storage clause is not specified for a nested table column or attribute.
*Action: Specify the nested table storage clause for the nested table column or attribute.

View 1 Replies View Related

Forms :: Getting Error ORA-200001 While Creating A New User?

Jun 10, 2011

I am creating a New User by using our customized Oracle Form for Creating a New User.

I am ting the Bellow errors:

-604-ORA-00604 : error occurred at recursive SQL level 1
ORA-200001 : failed to create user,please contact dba for support.
ORA-06512: at line : 16

I am using ORacle Forms 10g as a Front End and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production as Back end.

View 1 Replies View Related

SQL & PL/SQL :: User Is Creating Original Item Code Without Mm

Mar 28, 2012

i have a field in one table called item_name based on which i am creating new item name as duplicate with new given length, for eg there is one item_code which has length of 12000mm i am going and replacing the string using instr function and replace function based on criteria that where i will find mm it will extract a portion and replace the new length as 6300mm.But its failing because some time user is creating the original item code without mm, is there a way.

Original:'H194x150x6x9x8x12000mm, 29.9 kg/m, ASTM A992M'
New : 'H194x150x6x9x8x6300mm, 29.9 kg/m, ASTM A992M'

comes some times he is entering mm and sometimes he is entering without mm as

Original:'H194x150x6x9x8x12000, 29.9 kg/m, ASTM A992M'
New : 'H194x150x6x9x8x12000, 29.9 kg/m, 6300'

View 5 Replies View Related

Application Express :: Creating Forgot Password Page And Sending Mail To That User?

Apr 29, 2013

I need to create a forgot password page in which there will be two text box named user name and email id and user will provide his usename and email id in those text box. so apex will check that the provided name and email id are there in the data base and if email id corresponds to right user name then a mail will be send to that email Id containing auto generated password.

View 1 Replies View Related

Security :: Authenticating Oracle User Based On Windows User ID?

Mar 11, 2011

We are trying to implement the following security to our database.

As of now, the access rights are same for all the windows users logging into the Oracle application with the same Oracle user Id.

But now, we want to improve our security by granting different levels of rights to the users based on their Network Id even though they use the same Oracle User Id to log into the application.

We are not looking for the users to be identified externally.

(CREATE USER "OPS$ORACLE-BASE.COMTIM_HALL" IDENTIFIED EXTERNALLY;
GRANT CONNECT TO "OPS$ORACLE-BASE.COMTIM_HALL";
)

View 3 Replies View Related

Data Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?

Jul 1, 2010

Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?

View 1 Replies View Related

Server Administration :: How To Get Disk List On Any DB Instance That Uses ASM Instance

Mar 16, 2011

My context on our servers is the following one:

- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks

On each DB instance you can see:

- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view

So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?

View 6 Replies View Related

OS User Occupying Shared Memory As Oracle User

Dec 11, 2012

we are trying ti implement BMC monitoring tool for our oracle 11g2 RAC/solaris10 environment. for the purpose we create a user called bmcuser in OS level, this user connecting database to monitor, this user occupy shared memory as oracle. Explain why this user taking that much shared memory just to connect database using sqlplus.

oracle taking 55% bmcuser taking 44%,

SQL> show parameters memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3232M
memory_target big integer 3232M
shared_memory_address integer 0
SQL> show parameters sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3232M
sga_target big integer 0
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
6449 bmcuser 47M 44M sleep 23 10 0:57:31 0.2% PatrolAgent/1
[code]........

pga & uga usage sessionwise

SID     ORA_USR     OS_USR     S_PROG     S.MACHINE     S.PGA_MEM     S.PGA_MEM_MAX     S.UGA_M     S.UGA_M_MAX
252     (null)     oracle     oracle@racdev1.zakathouse.org (ARC3)     racdev1.     31054584     32168696     181056     181056
227     (null)     oracle     oracle@racdev1.zakathouse.org (ARC2)     racdev1.     31054584     32168696     181056     181056
177     (null)     oracle     oracle@racdev1.zakathouse.org (ARC0)     racdev1.     31054584     32168696     181056     181056
576     (null)     oracle     oracle@racdev1.zakathouse.org (LGWR)     racdev1.     16693544     21281064     181056     181056
326     (null)     oracle     oracle@racdev1.zakathouse.org (LMS0)     racdev1.     13753080     13753080     181056     181056
376     (null)     oracle     oracle@racdev1.zakathouse.org (LMS2)     racdev1.     13556472     13556472     181056     181056
[code]........

View 6 Replies View Related

Security :: How To Configure Oracle EM With Newly Created Oracle Instance On 10g DB

Dec 11, 2012

How to configure Oracle EM with newly created Oracle Instance on Oracle 10g DB,which is Single Instance DB but not RAC ,when I start the Oracle EM it is starting the default DB which created during Oracle Server Installation.

View 0 Replies View Related

Forms :: 10g And SSO On Development PC

Sep 20, 2010

if Oracle Developer Suite 10g version 10.1.2.3 can emulate single signon (SSO) on my development PC? I've seen the documentation for the Application Server mod_sso.conf etc.how does one test single signon on the development PC?

View 1 Replies View Related

MetaSolv Migration Development?

Oct 29, 2010

I would like to know what is metasolve migration, how it is done, is it a oracle product ??..

what is signficant for going / using metasolve migration tool / development for migration.

what exactly it will migrate, Need more FAQ's on Metasolve migration development / tools.

View 2 Replies View Related

Forms And Reports Development

Nov 29, 2010

Any step by step tutorial about Forms and Reports Development (10g).

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved