How can i shift my datafiles to other drive like d: , they have become very big. and i also want to take backup on other drive like d: and oracle is installed on c:
View 3 RepliesI installed oracle 11g successfully in my windows7 operating system. After installation it is not allowing me to access C drive. And in the properties of the drive the memory of C drive is shown 0 bytes. And other applications installed in C drive are also not working. Even after uninstalling oracle 11g access to C drive is denied.
View 7 Replies View Relatedwhile try to expdp on network drive. getting below error.how can we perform the expdp on network drive
Network location: \\tsclient\p\expdp
1.)SQL> show user
USER is "SYS"
SQL> create or replace directory exp as '\\tsclient\p\expdp';Directory created.
SQL>Grant read,write on directory exp to system;
2.)expdp system/xxxxx@orcl directory=exp dumpfile=EXP_orcl_072013.dmp logfile=EXP_72013_1.log schemas=('IIMS','CMMN')
Export: Release 11.2.0.2.0 - Production on Tue Jul 23 13:48:07 2013
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
how to format a drive using oracle forms 10g and shutting down the remote pc and a personal pc using oracle forms 10g. i am using windows XP2 as os.
View 2 Replies View RelatedIs oracle providing secure backup only for Tape drive not for disk(means Hard-disk),configure oracle secure backup.
View 1 Replies View RelatedI scheduled a RMAN backup job to take FULL database backup to a shared network drive.
RMAN Script used:
RMAN> run
2> {
3> allocate channel ch1 device type disk format '\\BACKUP1635\X$\ARC%U';
4> backup database plus archivelog;
5> release channel ch1;
6> }
Environment: Windows server 2003 OS and Oracle 10.2.0.4.0
Iam facing below error.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 02/20/2011 18:19:46
ORA-19504: failed to create file "\\BACKUP1635\X$\ARC1BM55JL8_1_1"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
I checked shared network drive and found READ/WRITE access for me. I am able to take RMAN backup in local system without any issue.
I want to open any drive or specific folder in forms 6i in when button press trigger like we open any drive and folder in my computer or folder in windows
View 3 Replies View RelatedIn my drive E: I'll have a space issue soon because one file is taking all space. SYSTEM01. DBF size is around 25GB. I want to know if I delete some data in my database I'll gain space.
View 2 Replies View Relatedis it possible to get information about free space on drive/path for example with some DBMS_*, UTL_* package or with stored function based on Java
(e.g. CREATE OR REPLACE FUNCTION GetFreeSpace(driveLetter IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'DiskSpace.getFreeBytes(java.lang.String) return java.lang.String') but for JDK 1.3
I am using the HOST command within Oracle Forms 10g on Windows server to copy a pdf file from the application server to a network folder on another Windows server.
The command works fine if I logon to Windows app server and type it. But it doesn't work when it is launched within Oracle forms using HOST. The command looks as follow
net use \\FileServer\e-file /user:usergroup\username password & copy D:\RepTmp\myReport.pdf \\FileServer\e-file\test\myReport.pdf
Oracle forms doesn't give any error message at all but the pdf file never gets there. Even when I map the network folder as "R:" drive on the Windows app server, a simple copy command like this does not work with HOST:
copy D:\RepTmp\myReport.pdf r:\test\myReport.pdf
Oracle Forms server is running as "SYSTEM" on the Windows server. If HOST won't work, is there any other way to copy the file other than using fpt?
create Oracle archived log to network drive instead of Local drive.
Is there anyway that i can get my archive log created on network drive instead of local drive.
As we want to save our storage space and want to keep archivelog on network.
Is there a way that if Archive log creation on Network drives falis, Oracle create Archivelog on Local drive.
We are running Data warehouse and on daily basis we have 22 to 25 Gig of Archive log created
I take a backup on PROD and want to use that backup on test to duplicate the PROD db.I ran this first on PROD:
catalog rman11cv/password@metarep
connect target /
RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'G:
estore\%U';
BACKUP DATABASE PLUS ARCHIVELOG;
I runs fine.map the network drive on my TEST machine. I run the script:
connect target sys/password@pdm;
connect auxiliary /;
run {
allocate auxiliary channel 'ch1' type disk;
SET NEWNAME FOR DATAFILE 1 TO 'D:oracleoradatadatabasedataSYSTEM01.DBF';
SET NEWNAME FOR DATAFILE 2 TO 'D:oracleoradatadatabasedataUNDOTBS01.DBF';
SET NEWNAME FOR DATAFILE 3 TO 'D:oracleoradatadatabasedataCWMLITE01.DBF';
[code]....
Its trying to read from the right backupset.But Im not sure it can see it:
channel ch1: reading from backup piece G:RESTOREN3MKSOMQ_1_1
ORA-19870: error reading backup piece G:RESTOREN3MKSOMQ_1_1
ORA-19505: failed to identify file "G:RESTOREN3MKSOMQ_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.failover to previous backup
Net view of the PROD host gives this:
D:oracleadminduplicatePDMTEST>net view myprod
Shared resources at myprod
Share name Type Used as Comment
------------------------------------------------------
restore Disk G:
The command completed successfully.
I want to configure rman backup for oracle 9i database on hp tape drive. Db is running in RHEL.
View 6 Replies View RelatedI have stored test.sql in shared mapped drive and i don't have previlege to rename but i can read-write access at folder level.
How do i run the below sql script?
@\ind-aaa est est.sql
Here \ind-aaa is the mapped drive name.
I am getting error that \ind not found.
I want to open a word document which is present in a shared drive in Microsoft word from my oracle 10g form.
View 2 Replies View Relatedhow to load the pdf data from c drive to the oracle tables to their respective columns in forms 6i.
View 4 Replies View RelatedI am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine
Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager
For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string
Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager
but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database
I wanna disable shift+tab key function not to be able to go to previous item. What should I do?
View 1 Replies View RelatedI'm trying to figure out, based on total scheduled shift time and scheduled breaks what the effective schedule time is by hour for a particular employee.
So I have a shift query that gives me this (using a cross-day shift here because they do happen-not sure if that will impact things):
Shift ID EmployeeID ShiftStart ShiftEnd
123 99 04/10/2013 21:00:00 04/11/2013 06:00:00
And I have a activity query that gives me
Shift ID EmployeeID ActivityStart ActivityEnd Type
123 99 04/10/2013 23:00:00 04/10/2013 23:15:00 Break
123 99 04/11/2013 02:00:00 04/11/2013 03:00:00 Lunch
123 99 04/11/2013 04:00:00 04/11/2013 04:15:00 Break
And I need a query that give me this:
Shift ID EmployeeID ShiftStart Hour Net_Scheduled_Time(min)
123 99 04/10/2013 21:00:00 04/10/2013 21:00:00 60
123 99 04/10/2013 21:00:00 04/10/2013 22:00:00 60
123 99 04/10/2013 21:00:00 04/10/2013 23:00:00 45
123 99 04/10/2013 21:00:00 04/11/2013 00:00:00 60
123 99 04/10/2013 21:00:00 04/11/2013 01:00:00 60
[Code]...
Is there a relatively easy way to get there in one query, no temp tables?
I wanted to create shift rota for the employees as per the below conditions.
1). Shift should be rotated.(it should check previous 2 shifts and assign to another shift).
2). The same employees should not be allocated for the next shift .
Ex : Now jones, jekku, henry and villiams are in "C" shift . So the same employees should not be allocated to the next shift, it should be random. Some of these employees should be allocated to "B" and some employees should allocated to "A" shift....
Below are the SQL statements to create the table and input the data..
create table resource_details
(empno number(5) ,
ename varchar2(30),
shift char(1));
alter table resource_details add constraint res_pk primary key(empno) ;
insert into resource_details values(51370 , 'Finney' , 'A') ;
insert into resource_details values(51371, 'Jerry' , 'B') ;
insert into resource_details values(51372, 'Jones' , 'C') ;
insert into resource_details values(51373, 'Smith' , 'A') ;
insert into resource_details values(51374, 'Krishna' , 'B') ;
insert into resource_details values(51375,'Chenna','A');
[code]....
I have tried with employee number to check which shift he is/was in & assigned the shift accordingly , but here shift is getting rotated but not employees(same employees are going to the next shift, which should not be accepted..)
i m trying to display a field when shift+f4 is pressed. but i don't know the trigger in which the code needs to be written.
View 8 Replies View RelatedWhen i open the form,select a radio button and immediately do a SHIFT+TAB form hangs.
After selecting the radio button if i do a TAB and then do shift+tab it works fine for me.
There is no KEY-PREV-ITEM trigger in radio group.For my testing i have also written go_item in this trigger,but still it fails.
I have a 10G Express system running. I Have 2 tablespaces in production. WHen taking backup, it terminates unsuccessfully saying system01.dbf is damaged. The application works fine and no data loss is found through the application interface.
So can I shift the data to a new server using the dbf files of the tablespaces in use?
I have a tablespace PLUS_IX with 5 datafiles PLUS_IX_01, etc.
PLUS_IX_04 is 85% full, up from 78% last month
PLUS_IX_05 is 22% full.
PLUS_IX_01 to _03 are 73% full.
Should I be concerned that PLUS_IX_04 is getting full? If so, what actions are recommended?
ALTER INDEX ..... REBUILD has been run on all the indices.
I read this article:
[URL]......
Does it work with copying datafiles from 10g2 to 11g2? I want to move one huge tablespace (which contains one table) from 10g2 to 11g2, what is the best method to do that?
Basically , we have a large index tablespace , whose data files already spans multiple mount points , and has been extended with a new data file on a wrong mount point by mistake , Can we relocate this last datafile extension , to a different mount point while the DB is online ? Is there any special consideration for index datafiles (If such classification is correct ) or is it just like any other Oracle non-system datafile ?
What will be the effect on the normal data tables which are using this index if they are being accessed during the exercise? This is a 2 node Oracle 9i 9.2.0.8.0 RAC on Veritas Cluster .
How to move the datafile from e-drive to d-drive in oracle 11g?
View 7 Replies View RelatedI am looking for a way to monitor the creation of new datafiles / tempfiles.Let's say I am creating a new datafile of 8GB in size, and it takes a few minutes to create.
I have looked at v$session_longops, and several other system views, but cannot find any that indicate how the file creation is progressing.
I want to be able to display something simple, such as "72% complete".
i want to delete one datafile from tablespace witch contain 2 datafiles
i did
ALTER DATABASE DATAFILE 'ton_fichier' OFFLINE DROP;
and delete the file physiquly but i have already my datafile witch i have delete in my tablespace
11.2.0.2 on Solaris..I have such a large post on a very basic space calculation.
We have several tablespaces starting with WLMCS in our DB..I just wanted to calculate the total space consumed in the disk by all these tablespace combined .When I queried DBA_DATA_FILES.MAXBYTES and DBA_DATA_FILES.USER_BYTES , I've noticed that ,
When AUTOEXTEND is NO: MAXBYTES is 0 for these datafiles . But USER_BYTES won't be 0 for these files
When AUTOEXTEND is YES: MAXBYTES will be a non-zero value for these datafiles . USER_BYTES won't be 0 either for these files-- Not including datafile names for better readability.
SYS > select tablespace_name, maxbytes/1024/1024, user_bytes/1024/1024, autoextensible from dba_data_files where tablespace_name like 'WLMCS%';
TABLESPACE_NAME MAXBYTES/1024/1024 USER_BYTES/1024/1024 AUT
------------------------- ------------------ -------------------- ---
WLMCS_DATA 32767.9844 32766.9375 YES
WLMCS_DATA 32767.9844 31615.875 YES
WLMCS_DATA 32767.9844 16419 YES
WLMCS_OAT_DATA 32767.9844 32766.9375 YES
[code]....
11 rows selected.To calculate the space consumed , I made 2 assumptions.Are the below 2 assumptions right?
Assumption 1. Whenever MAXBYTES = 0 , USER_BYTES should be considered for the space calculation.
Assumption 2. Whenever you have non-zero values for both MAXBYTES and USER_BYTES , MAXBYTES should be considered for the space calcuation.I did the calculation (adding up of) based on the above assumptions. Is this calcualtion Correct ?
-- Not including datafile names for better readability.
TABLESPACE_NAME MAXBYTES/1024/1024 USER_BYTES/1024/1024
------------------------- ------------------ --------------------
WLMCS_DATA 32767.9844 32766.9375
WLMCS_DATA 32767.9844 31615.875
WLMCS_DATA 32767.9844 16419
WLMCS_OAT_DATA 32767.9844 32766.9375
[code]....