السلام عليكم

المشكلة عندي أن نظام التشغيل و قواعد البيانات موجودين على المحرك c

و قد تفحصت حجم الفراغ في هذا المحرك فوجدته قليل و اقترب أن يمتلئ

هل هذه المشكله ستؤثر على عمل قاعدة البيانات هناك متسع في المحرك c

فهل يوجد طريقة لنقل لبيانات على d

و شكراً

salam,
you didn't say what version of oracle.
basicley, you car move the physical files of the database to another location. for this you must recreate controlfiles.
see alter database backup controlfile to trace ans cloning database for more information.
hope this helps

hi

you can use OEM to alter the datafiles path

but first u has to alter the tablespace offline and change the datafile path and then alter tablespace online

any help regarding this solution u can msg me

good luck

Hi,
Thanks for your answer this question, but I need to know :
- What is the OEm?
- How can I Alter the datafile path?
- How can I alter the tablespace offline and online?

I will be appreciate if you can feed-me-back soon


Thank You.

Hi,
    Thanks for your answer this question, but I need to know :
- What is the OEm?
- How can I Alter the datafile path?
- How can I alter the tablespace offline and online?

I will be appreciate if you can feed-me-back soon


Thank You.

49613[/snapback]

OEM يعني ORACLE ENTER PRISE MANAGER


طبق الامر التالي

ALTER DATABASE 
RENAME FILE 'C:\YOUR_DATA_FILE_NAME.dbf ' TO 'D:\YOUR_DATA_FILE_NAME.dbf';

ملاحظة قم بعمل BACKUP --- EXPORT
قبل البدء بأي شيء

Hi,
    Thanks for your answer this question, but I need to know :
- What is the OEm?
- How can I Alter the datafile path?
- How can I alter the tablespace offline and online?

I will be appreciate if you can feed-me-back soon


Thank You.

OEM يعني ORACLE ENTER PRISE MANAGER


طبق الامر التالي

ALTER DATABASE 
RENAME FILE 'C:\YOUR_DATA_FILE_NAME.dbf ' TO 'D:\YOUR_DATA_FILE_NAME.dbf';

ملاحظة قم بعمل BACKUP --- EXPORT
قبل البدء بأي شيء