• RELEVANCY SCORE 4.29

## DB:4.29:Webupload In One Db 1m

I have a Problem and hope anybody can me help.

We have the Vbulletin Board and I would upload Picture, the new layout and another stuff in one MySQL DataBase over the Web CP but no upload files are in the DB!

I have a another Script too and this doesnt work too (Script to Upload in one DB)

No PHP Script that upload stuff in a database work.

I think Apache or so have a Problem with Plesk?

The Configuration wasnt changed while this time for upload or so.

I hope you can me help.
Thank you!
Seinfeld

## DB:4.29:Webupload In One Db 1m

Add the following to your vhost.conf for the domain in question (change the paths according to your version of PSA):
Directory /usr/local/plesk/apache/vhosts/domain.com/httpdocs
/Directory

• RELEVANCY SCORE 2.88

Menu - galery - pictures/videos - options - transfer by webupload . This is where my N73 says:"function is not supported" Firmware 4.0726.2.0.1 Anyone experienced the same problem ?

Menu - galery - pictures/videos - options - transfer by webupload . This is where my N73 says:"function is not supported" Firmware 4.0726.2.0.1 Anyone experienced the same problem ?

• RELEVANCY SCORE 2.82

## DB:2.82:Two Process Access One Db dp

How to set up in the Java program that one process write the data into DB and the other process read ONLY the data from that DB?

Thanks.

## DB:2.82:Two Process Access One Db dp

Hi,

Can you post a complete working example? Without that I can't trace the execution of your code.

The example should compile and run without my needing to add code to get it to work.

Ron

• RELEVANCY SCORE 2.71

## DB:2.71:Abap Results In Db Tables 87

Hello all

Can any one tell me in Which DB tables ABAP Results will be stored?

Thanks

Oli

## DB:2.71:Abap Results In Db Tables 87

MANY MANY THANKS...sUBRAMANYAN.......

oLI

• RELEVANCY SCORE 2.63

## DB:2.63:Ods Settings In Sap Me 5.2 mm

Dear All,

Can any one tell me what is the settings for data movement from WIP DB to ODS DB in SAP ME 5.2 .

Thank you.

## DB:2.63:Ods Settings In Sap Me 5.2 mm

Sivajit,

Setting up ODS processing is described in the [guide|https://websmp209.sap-ag.de/~sapdownload/011000358700000699622009E/ODSRG_SAPME_52_FINAL.pdf], however, this is mainly a task handled by SAP Consulting due to a number of different factors which need a thorough consideration before starting ODS processing in production. Also, you can find several SAP Notes searching by "ODS".

ODS Rule Maintenace can be found in Activity Manager of SAP ME MAINTENANCE ODS Rule Maintenance.

Regards,

Sergiy

• RELEVANCY SCORE 2.55

## DB:2.55:Ejb Db Access, Jms And Transactions z7

I have an EJB doing something in the database and writing a message to a JMS queue (using jdbc persistence in the same database) in one transaction. Do I need an RDBMS with distributed transaction support for this?A container could find out that the queue access should use the same db connection (it does so when different EJBs access the DB in one transaction) , but I have the impression that JMS uses its own connection, so we have one DB user for EJBs accessing the DB and another DB user for accessing the queue tables. Am I right? - Michael

## DB:2.55:Ejb Db Access, Jms And Transactions z7

Thank you. BTW, I did search the forum - maybe using the wrong keywords. - Michael

• RELEVANCY SCORE 2.48

## DB:2.48:Db Manual 9c

Hi, I'm new in the LabVIEW and Iwant to do an aplication with DB and I need one DB manual or user guide. Could someone give me a web adress or send me a .pdf manual??

Thanks. Bye.

## DB:2.48:Db Manual 9c

The manual for the Database Connectivity Toolkit can be found at http://digital.ni.com/manuals.nsf/websearch/F0E037​61C7F4ACB486256A3E00509BA9. If you bought the toolkit, you should have received the manual. If you didn't buy the toolkit, the manual won't help you much.

• RELEVANCY SCORE 2.45

## DB:2.45:Got 3 Parallel Web-Servers That Read From One Db , I Want The Db To Allow Only One Web-Server zd

Got 3 parallel web-servers that read from one db , i want the db to allow only one web-server
reading from the db each time.

I want to lock the db from allowing access from the others web-services ,when one web-service start it reading.

I like to do it in the db level C#.

any suggestions ?

## DB:2.45:Got 3 Parallel Web-Servers That Read From One Db , I Want The Db To Allow Only One Web-Server zd

You could also use Logon triggers maintaining a table where the state which server is able to connect can be maintained. This would be one step before the procedure calls mentioned by the fellow poster, would be the non-friendly way of not allowing access :-)

-Jens

• RELEVANCY SCORE 2.44

## DB:2.44:Re: Removing .Db Files dp

Does someone have any answer to that one?

## DB:2.44:Re: Removing .Db Files dp

Many thanks for the detailed answer.

• RELEVANCY SCORE 2.40

## DB:2.40:Loading A Query Result From One Db To Another Db x7

Hi All,

I am running in a large query on one Oracle DB and I would like to load the returned result set in this DB into another Oracle Database.. Any help regarding a better solution of achieving this task would be much appreciated....

Thanks!!

## DB:2.40:Loading A Query Result From One Db To Another Db x7

Thanks very much for this information Srini.... You put me in a right direction!!

• RELEVANCY SCORE 2.39

## DB:2.39:Re: Move Spfile c1

I might be missing something here - but it still didn't work. Here are the sequence of steps:
1.With db up, create a pfile from spfile
2. shutdown db
3.startup db with the pfile from step1
4.create spfile in new loc.
sho parameter spfile here shows nothing
5.shutdown db
6. start db again with pfile
sho parameter spfile here still shows nothing
7.Rename old spfile (the one used in step1) so that db does not pick up.
8.start db with new spfile create in step4
Db does not start
9.so started db by putting old spfile back in place.

## DB:2.39:Re: Move Spfile c1

Folks - Thanks for all those great responses. This is a great group. However I never mentioned that this is a RAC env. My bad. So most if not all of the above response will work if the db is a standalone. Also, even in RAC if I bring each instance manually, it seemed to work showing the new spfile when sho parameter spfile command was issued. However, if I tried to start the db using the srvctl utility it fails. The reason I believe is that this info is stored in OCR. So srvctl utility has a command to modify which modified the cluster registry and I am good to go.

Here is the actual command I used:
srvctl modify database -d estee -p /u13/oradata/estee/spfileestee.ora
ofcourse that is after creating pfile first and then creating spfile in above location from the pfile.

Thanks to you all again. I just thought to close this discussion gracefully.

• RELEVANCY SCORE 2.38

## DB:2.38:Re: Db Link Not Visible z3

There are two separate nodes for database links in the connection navigator for SQL Developer - one for DB links owned by the current user and another for public DB links. I am on 1.5 EA3 (5304) and can see public DB links in the "Public Database Links" node.

theFurryOne

## DB:2.38:Re: Db Link Not Visible z3

I opened a SR and the Oracle Support was able to reproduce the bug...
Now it's bug 6992652 on Metalink
:)

• RELEVANCY SCORE 2.37

## DB:2.37:Wag160n - Connection Problems + Showtime Retrain ds

Ok been having alot and i mean alot of connection problems in the last 3 days, but one thing i noticed is this

--- System Information ---
ModelName: WAG160N
Firmware Version: A1.00.15 , 2009-05-31T16:58:02
GUI Version: A1.00.15_007
Boot Version: 1.0.37-5.4
Hardware Version: 0.01

--- DSL Information ---
DSL Driver Version: AnnexA version - A2pB022g.d20e
DSL VPI/VCI: 0/38
DSL Status: ShowtimeRetrain Reason: 8000
DSL Channel: FAST
DSL Upstream Rate: 1017 Kbps
DSL Downstream Rate: 16476 Kbps

Down up
DSL Noise Margin: 8.9 dB 9.6 dB
DSL Attenuation: 26.5 dB 12.6 dB
DSL Transmit Power: 0.0 dBm 12.8 dBm

then sometimes this happens

--- DSL Information ---
DSL Driver Version: AnnexA version - A2pB022g.d20e
DSL VPI/VCI: 0/38
DSL Status: ShowtimeRetrain Reason: 8000
DSL Channel: FAST
DSL Upstream Rate: 1017 Kbps
DSL Downstream Rate: 15897 Kbps

Down up
DSL Noise Margin: 9.1 dB 9.4 dB
DSL Attenuation: 27.0 dB 12.8 dB
DSL Transmit Power: 0.0 dBm 12.8 dBm

- Show time Retrain 0 then 8000 what is this?

also my noise ration seems to jump alot.

DSL Noise Margin: 2.3 dB 17.0 dB
DSL Noise Margin: 1.4 dB 16.4 dB
DSL Noise Margin: 0.7 dB 16.1 dB
DSL Noise Margin: 0.3 dB 15.5 dB
DSL Noise Margin: 1.0 dB 15.5 dB
DSL Noise Margin: 2.6 dB 17.4 dB
DSL Noise Margin: 0.6 dB 16.0 dB
DSL Noise Margin: 0.7 dB 15.9 dB
DSL Noise Margin: 2.3 dB 17.9 dB
DSL Noise Margin: 2.6 dB 17.3 dB
DSL Noise Margin: -5.7 dB 8.9 dB
DSL Noise Margin: 10.4 dB 9.8 dB

another thing was that sometimes the transmit power changes to 0.

DSL Transmit Power: 19.5 dBm 12.8 dBm
DSL Transmit Power: 0 dBm 12.8 dBm
Message Edited by ApophisXP on 07-08-2009 05:13 AM

## DB:2.37:Wag160n - Connection Problems + Showtime Retrain ds

Hi, Just a though, if the connection is still dropping, with a completely different modem/router then surley this would point tho the dsl service being at fault, or even a cable fault that is maitained by your telco/dls provider?

My dsl had a similar problem that I could not connect above 8mbps, then I replaced the telcos extension wiring for new cable and now i connect at 10mbps

anyways I hope you get serted soon.

• RELEVANCY SCORE 2.37

## DB:2.37:Thread: Inventory Zfs / Zfd Uses The Same Db? 7z

Hi,

what is the recommendation? We want to use ZfD-Inventory and

ZfS-Inventory. We have to use a Ora-DB-Server. OK, that is not a

problem. But just in the Moment i have only one DB with one DB-object.

It is better to use a single DB for each Inventory (one for ZfS and an

other for ZfS)?

Bye Bernd

## DB:2.37:Thread: Inventory Zfs / Zfd Uses The Same Db? 7z

Bernd Nachtigall,

I think i can create a second DB-Object and use it for ZfD?

Hum, let me dig more, as we have zfs, mms, nal, etc.

-' + '-

Jared Jennings

Data Technique, Inc.

Novell Support Forums Sysop

http://wiki.novell.com

• RELEVANCY SCORE 2.37

## DB:2.37:" Sales Contract " Master Database Tables (Db Tables) In Crm Sap xx

Can any one tell me the "Sales contract" db tables and master data tables for header and item level details in CRMSAP..

## DB:2.37:" Sales Contract " Master Database Tables (Db Tables) In Crm Sap xx

don't cross post.

• RELEVANCY SCORE 2.36

## DB:2.36:Archive Logs z7

we have two oracle 9i db server, at different locations in archive log mode and have both entire schema db structure is same....due to some problem one server db changes are behind....

is it possible to apply the one location db server archive logs to another server..
how to apply, pls suggest me....

## DB:2.36:Archive Logs z7

I just posted a new set of graphical tools to manage, monitor and tune the oracle database.
One of the many functions is an interface to Oracle logminer. It helps you set the parameters, define the criteria and view/extract SQL statements. The help part of this function also describes the steps required to use the logminer. It is free and can be downloaded from http://www.odbtools.com/ (www.odbtools.com/download.htm). I will greatly appreciate any suggestions.

Feel free to email me if you have any questions about logminer.

Michel Bartov
http://www.odbtools.com

• RELEVANCY SCORE 2.36

## DB:2.36:Call A Pkg Of Another Data Base Via Dblink 7z

call a package from another database by dblink oracle

call a package from another database by dblink oracle , i got one pkg in DB A and i got dblink in DB 2 to DB A
now i wnt to call the pkg og DB A from DB 2

Thanks

Raj

## DB:2.36:Call A Pkg Of Another Data Base Via Dblink 7z

• RELEVANCY SCORE 2.35

## DB:2.35:Export All Tables Except One Table 7c

i have db with more than one user
i need to export all tables in DB except one table

## DB:2.35:Export All Tables Except One Table 7c

Hi

• RELEVANCY SCORE 2.35

## DB:2.35:Difference Between A Mssql Db Within Visual Studio And Mssql External Db With One Of The Mssql Server 9c

What are the differences between creating a DB from VS and attaching an external one created with MSSQL server management tools.
If I deploy my application with a DB created in VS, do I need to buy space for a DB?

## DB:2.35:Difference Between A Mssql Db Within Visual Studio And Mssql External Db With One Of The Mssql Server 9c

For example, if you are going to send this to a hosted environment, for example a server you rent, the server needs to have SQL Server express installed for it to work.
Target machine = typical the web server you are going to run the website on.Best regards Arild Røksund, Norwegian developer (SQL & .net), Omega AS (please Vote as helpful if helpful)

• RELEVANCY SCORE 2.35

## DB:2.35:How Can Change Database One To Another In Oem 10g 33

hello
i have oracle 10g db 10.1.0.2.0 R2.
and 2 db 1. oracle(db_name) approx 5GB 2. oracle1(db_name) approx 2GB
now i am using OEM 10g or db managing.and manage oracle db through OEM.
but i want manage oracle1 db through OEM so what should i do..

very soon...
thanx.

## DB:2.35:How Can Change Database One To Another In Oem 10g 33

True,You can also choose this option during creation of database by dbca

• RELEVANCY SCORE 2.35

## DB:2.35:Cant Find The Relational Tfs Db f1

Hi,
How can I locate the running TFS relational DB?
On the TFS server I checked all the relational DB which contain a _WarehouseUpdate table in order to see which might be our running TFS DB. I found 3.

In each of these I ran query

SELECT
MAX(LastUpdatedDateTime) FROM WorkItemHistoryView
In order to see which one was most recently updated (indicating it is the relevant running TFS DB) , but unfortunately all returned dates in 2012 so I guess they're not our running
TFS DB.
How can I find our TFS relational DB?

Namnami

## DB:2.35:Cant Find The Relational Tfs Db f1

I've tried setting up the reporting configurations for the TFS Application Tier, and so I found my reporting services is under sharepoint integration mode. I changed it to use a new DB using native mode and deleted its encryption keys. I then restarted the
reporting services service.
All the above was from
Then I returned to the TFS reporting configuration but when I tried applying the TFS DB (I tried existing / new names) I get an error:

Failed to add ourdomain\Domain Users account to the TfsWarehouseDataReader role on the tfs-WarehouseXXX relational database
I entered the above database role and it already has the above account. I tried removing the account from the role and the trying to set the reporting configurations on the TFS administration console but I keep getting this error.

• RELEVANCY SCORE 2.35

## DB:2.35:Run Queries Off Of Oracle Connection Using Data In An Access Db mz

I have connections for both an Access DB on my computer as well as an Oracle DB in SQL Developer.

Is it possible to run a query in an Oracle connection by linking data from an oracle table to one of the tables in the Access DB?

## DB:2.35:Run Queries Off Of Oracle Connection Using Data In An Access Db mz

Nice! Thanks for the information this is really cool stuff, lots to learn...

• RELEVANCY SCORE 2.35

## DB:2.35:How To Set Xml Db Parameter pj

HI,

Can any one plz tell me how to set xml db parameter in oracle 11g xe

## DB:2.35:How To Set Xml Db Parameter pj

How do you mean parameter? Do you mean like "on" / "off" ?

Oracle XMLDB functionality is installed via the script $ORACLE_HOME/rdbms/admin/catqm.sql • RELEVANCY SCORE 2.35 ## DB:2.35:"Sales Contract" Master Data Tables (Db Tables) In Crm Sap x3 Can any one please tell me the "sales contract" db tables and master data tables for header and item level details in CRMSAP . ## DB:2.35:"Sales Contract" Master Data Tables (Db Tables) In Crm Sap x3 Hi Piyush,Try, tables, CRMD_ORDERADM_H (Field 'Process_Type' for Header), CRMD_ORDERADM_I (Field 'Object_Type' for item).Hope it works.Regards,S Reddy • RELEVANCY SCORE 2.35 ## DB:2.35:Trouble With Docroot Being On Mount Drive 38 I have a situation where I created an instance under SWS 6.1 to a web site that was physically located on a mounted drive. Example: The docroot of the instance pointed to: /webupload/mywebsite "/webupload" is really a mounted drive to "/nfs/nt/web/staging" All of the appropriate folders, etc. exist and work just fine. i can access static pages just fine. But the struts parts do not seem to work. From the logs it appears that the WS is picking up the web.xml, struts-config.xml and all of the other files, but doesn't seem to be able to run the struts actions. I can view .jsp files just fine as well using the approach so it's not a compiler issue. My guess is something during instance start-up is failing that isn't allowing struts to completely initialize, but otherwise I'm stuck. If I do a normal deployment, where I have the folder local to the server (not on the mount drive) and deploy the site as a .war file, it works fine. I also know that in Production, we have exactly the same setup except we're using SAS7.x and it's working fine, but with SWS it seems to have an issue with the mount point and web applications... ## DB:2.35:Trouble With Docroot Being On Mount Drive 38 I got this to work but not as I was attempting. Apparently, mounting a "web application" as docroot works, meaning, it loads without error, but when you try to run anything except simple JSP and static content, the web.xml, sun-web.xml it's not executed. Elements such as struts-config.xml is loaded but SWS is unable to find the action. See a typical access log entry. 10.200.82.7 - - [25/Apr/2005:08:40:51 -0400] "GET /Banner.do HTTP/1.1" 404 6848 Nothing is written or displayed in the error log, even on finer. Now, I did say I got this to work. If I create a WEBAPP manually in the server.xml file and point it to the mount point and specify the context root (uri) as "/", it works fine (see tag below). WEBAPP uri="/" path="/webupload/extranet/mywebsite.com" enabled="true"/ • RELEVANCY SCORE 2.35 ## DB:2.35:File Upload To Specific Directory ... Plz Help f3 Hi, Friends, I need to upload file to specific path : since i have not worked with file upload yet. so please provide me help regards this. i have seen apache commons file upload but did not understand it. please if i would have some code to start implement its good for me. since i m not expert, so please provide through simple JSP code. if path is local like : c:/test/upload then what to do and want to upload in sever : http://localhost:8080/webUpload/ in specific directory say uploads then what to do ? plz i want to do : =============================================== File should be PDF and JPG only. and user can have two or more browse selection for file ( like yahoo mail attachment provides) since size 10 MB for both. it would better for help. its new for me.. how to do/ Edited by: Ghanshyam on Sep 18, 2007 10:55 AM ## DB:2.35:File Upload To Specific Directory ... Plz Help f3 Hi, If you are using Struts based application. This will be very much useful. Day before only i tried. This page helped me a lot. I hope it will be useful to you also. http://wiki.apache.org/struts/StrutsFileDownload Regards, Rajkumar S C • RELEVANCY SCORE 2.35 ## DB:2.35:Update Remote Db With Local Db 73 i have one online db and local db local db is sourcedb and online db is destination db... i need to list no of tables that destination db had'nt and source db had 2. Changes happened in online db when compare to local db...(eg: additional columns and its datatypes...) 3. Number of addtional store procedure ....had in local db when compare to online db and for i want to create sp on online db...which had'nt on online db 4. changes in sp in local db...when compare to online db sp....for editing online db sp.... is there any query....to do all this things.... I will explain all the context....i have to two db one local and online.... for my website i worked of local db and made some changes i want to made those exact changes on my online db......is it any solution. ## DB:2.35:Update Remote Db With Local Db 73 and made some changes i want to made those exact changes on my online db......is it any solution. In common a database developer uses change script to modify a database, first on the developer database and if it works also on the productive database; do you have these script or have you made all changes only via SSMS UI? See e.g. TechNet Script Center: http://gallery.technet.microsoft.com/scriptcenter/Compare-two-databases-for-b44e7afa http://gallery.technet.microsoft.com/scriptcenter/Compare-Sync-Database-761f9337 http://gallery.technet.microsoft.com/scriptcenter/12b98927-b464-4330-a8f0-e55ad8998a62 Olaf Helper [ Blog] [ Xing] [ MVP] • RELEVANCY SCORE 2.35 ## DB:2.35:Toplink Blob Handling 88 when we use a serailized mapping in toplink to write objects to database, Does toplink add any special headers/bits to the data written as a binary blob into the DB? When we migrate blob data from one DB to another DB external to Toplink, Toplink is unable to deserialize the data from the DB, we compared the data in both the original and the migrated DB, the blob data looks fine. Thanks ## DB:2.35:Toplink Blob Handling 88 I had to write custom blob handling for migrating oracle blobs to MySql blobs. • RELEVANCY SCORE 2.34 ## DB:2.34:Can I Create More Than One Db In A Machine? 77 can i use "create database" to create more than one db in a single machine? ## DB:2.34:Can I Create More Than One Db In A Machine? 77 also So can you install more than one database on a server? Yes Is it better to have one database per server? Yes Is it always justified to have one database on a server? No Can we make sure that company security audit will allow such RISK No (most cases) :-) cheers • RELEVANCY SCORE 2.34 ## DB:2.34:Thread: Errors In Buexec Backup Log For Zen ac NW6 SP3 server with BE 9 installed The following warnings occur on a regular basis during my backup. Is this normal or can I do anything to avoid these issues? Should I be unloading ZEN during my backup? ##WRN##WARNING:File \\ZENworks\\Inv\\server\\WmInv\\logs\\zenworksinvservice \\zenworksinvservice-031022 144651310.txt was backed up while in use. ##WRN##WARNING: File \\ZENworks\\RemMgmt\\server\\logs\\trace-031022144645796.txt was backed up while in use. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb.log or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb1.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb10.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb11.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb2.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb3.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb4.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb5.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb6.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb7.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb8.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\mgmtdb9.db or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\Inv\\DB\\~HM.AAA or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\NAL\\DB\\NAL.DB or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\NAL\\DB\ al.log or one of its streams is in use - SKIPPED. ##WRN##File \\ZEN_db\\zenworks\\NAL\\DB\\~HO.AAA or one of its streams is in use - SKIPPED. -' + '-' + '- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003 ## DB:2.34:Thread: Errors In Buexec Backup Log For Zen ac Robin, the official backup method is through ConsoleOne - it works just fine, but you can\'t automate it. -' + '- Shaun Pond Novell Support Connection SysOp • RELEVANCY SCORE 2.34 ## DB:2.34:Using Indexes fa could any one send me a link about using indexes in oracle DB ## DB:2.34:Using Indexes fa Ciao Paul, as you said in the other thread, two different interpretations are better than one...:-) • RELEVANCY SCORE 2.34 ## DB:2.34:Master Detail Report Question kj I have master and detail report , 1 master column have 1 detail column(but several rows for that master ) . I would like to display it in following format , basically , I want it to display all these in one single page . side by side hostname1 hostname3 hostname6 ---------- ------------------ ----------------- db name1 db name1 db name1 db name2 db name2 db name3 hostname7 db name5 ---------------------- hostname4 db name1 ------------------ db name2 hostname2 db name1 db name3 ---------------- hostname5 db name1 ---------------- db name2 db name1 db name2 ## DB:2.34:Master Detail Report Question kj Hi, There are several possible ways to achieve this. Have a look at: Re: Grouping on reports (not interactive) Andy • RELEVANCY SCORE 2.34 ## DB:2.34:Borland Bds 2006 C++ And Oracle Db? 3x Hi How to connect and work with Oracle DB from Borland BDS 2006 C++? There are several types of built-in DB connection components. Are they usable? Which one of them? Server version is Oracle DB 10g Please advice. Edited by: 994317 on 17-Mar-2013 02:20 ## DB:2.34:Borland Bds 2006 C++ And Oracle Db? 3x Hi How to connect and work with Oracle DB from Borland BDS 2006 C++? There are several types of built-in DB connection components. Are they usable? Which one of them? Server version is Oracle DB 10g Please advice. Edited by: 994317 on 17-Mar-2013 02:20 • RELEVANCY SCORE 2.33 ## DB:2.33:Db Connect: View's From Other Users p8 Hi,In BW 3.5 is it possible to create DB Connect DataSource for views which are under User other than the one used for BW - DB Connection.Thanks,CD ## DB:2.33:Db Connect: View's From Other Users p8 Hi,Check out the link for ur requirement:http://help.sap.com/saphelp_nw2004s/helpdata/en/a6/4ee0a1cd71cc45a5d0a561feeaa360/frameset.htm • RELEVANCY SCORE 2.33 ## DB:2.33:Re: Application Connection To Timesten In-Memory Database a3 Hi Chris, One more thing I want to know, We are working on distributed databases. First I want to tell you how our databases is working our plan about TT DB. We have 2 ORACLE DB, First is switch(A) 2nd is (B) , the the users transaction comes to DB (A) first from DB (A) it goes to DB (B). On database (B) we have made different link for other databases so from DB (B) the transaction is going to next database. Now we are in the planing of making TT DB for database (A) (B) only. So I have one confusion that how the users transaction will work that means from TT DB (A) transaction will go on TT DB (B) but what is next ..... ?? Is it good practice to make TT DB in distributed databases. Thinks Regards, Atul Mandale. ## DB:2.33:Re: Application Connection To Timesten In-Memory Database a3 Same as for other Oracle DB products. Licensing is based on the number of CPUs (adjusted by any relevant multi-core factor) in the machine where TimesTen is running. Chris • RELEVANCY SCORE 2.33 ## DB:2.33:Data Migrate From One Access Db To Another Access Db Using Vb.Net 1x Hi All, How to Data Migrate from One Access DB To another DB using VB.net? Example: Existing DB Name : Lakshmi.ACCDB New DB Name :naraayanan.ACCDB The Data transfer from Existing DB To New DB. Note: in New DB , we added some Columns one Table , in that table already in the Existing Table. ## DB:2.33:Data Migrate From One Access Db To Another Access Db Using Vb.Net 1x You can use an INSERT statement to copy data between databases: Dim AccessConnection As New System.Data.OleDb.OleDbConnection(Provider=Microsoft.ACE.OLEDB.12.0; _ Data Source=pathToDatabase\naraayanan.ACCDB) AccessConnection.Open() 'Different table structure: Dim AccessCommand As New System.Data.OleDb.OleDbCommand(INSERT INTO [TableName] (Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM [MS Access;DATABASE=pathToDatabase\Lakshmi.ACCDB;].[TableName], AccessConnection) 'Or, if table structure is identical: Dim AccessCommand As New System.Data.OleDb.OleDbCommand(INSERT INTO [TableName] SELECT * FROM [MS Access;DATABASE=pathToDatabase\Lakshmi.ACCDB;].[TableName], AccessConnection) AccessCommand.ExecuteNonQuery() AccessConnection.Close() Paul ~~~~ Microsoft MVP (Visual Basic) • RELEVANCY SCORE 2.33 ## DB:2.33:Why Db Link ? fc Hi all, We are trying to access the other DB (target) view information in a VB code . There are two ways 1. DB Link in source DB and acess using source DB connection in VB code. 2. Access the view using target DB connection in VB code. Which is preferred ? and target DB is not remote and the two DBs are not related but just sharing information (one-way/read/target to source). Does DB link add any additional performance challenges (memory/sessions ) as we already have a big source DB ? Does links creates temp tables/views in source DB ? Thanks ## DB:2.33:Why Db Link ? fc Whatever is easier for you. Does DB link add any additional performance challenges (memory/sessions ) as we already have a big source DB ? No Does links creates temp tables/views in source DB ? No • RELEVANCY SCORE 2.33 ## DB:2.33:Will One Mrp Process Be Created For Each Standby Db? a3 Version:11.2 on RHEL 5.8, Solaris 11Will one MRP (Managed recovery process) be created in the server for each standby DB created ? ## DB:2.33:Will One Mrp Process Be Created For Each Standby Db? a3 Hello;Consider this simple command :ps -ef | grep ora_mrpBest Regardsmseberg • RELEVANCY SCORE 2.32 ## DB:2.32:What Is The Advantedge Of Clientpart-Wcf-Serverpart-Db Vs Clientpart-Db j7 I worked in one company we had a large database application. And it architecture was : ClientPart-DB ( I mean client part connect to db ) But now in another company Architecture is more complex : ClientPart-WCF-ServerPart-DB What is the advantedge of it ? Why do not simple to use ClientPart-DB ? When make application as ClientPart-DB and when ClientPart-WCF-ServerPart-DB ? I create my super player Media Glass ## DB:2.32:What Is The Advantedge Of Clientpart-Wcf-Serverpart-Db Vs Clientpart-Db j7 But now in another company Architecture is more complex : ClientPart-WCF-ServerPart-DB What is the advantedge of it ? Why do not simple to use ClientPart-DB ? When make application as ClientPart-DB and when ClientPart-WCF-ServerPart-DB ? Hi dcya, Welcome to MSDN Forum. The architecture ClientPart-WCF-ServerPart-DB you talked about, is a typical distributed application architecture. Such architecture generally is required for large enterprise site. It's more secure for the underlying database and it can reduce the complexity associated with applications within the enterprise space. You can know about: Distributed Application Architecture Overview http://msdn.microsoft.com/en-us/library/aa291880(v=vs.71).aspx Enterprise Template architecture is designed to be consistent with the multitier distributed application commonly used in the Enterprise computing development space. The following shows the corresponding layers: Layer Functionality User Services WinUI and/or WebUI, WebServices, WCF Business Services BusinessFacade, BusinessRules Data Access and Persistence DataAccess Other SystemFrameworks Martin Xie [MSFT] MSDN Community Support | Feedback to us • RELEVANCY SCORE 2.32 ## DB:2.32:Mutliple Db In Asm 9z Hi, Db : 11.2.0.3 Os :Aix We have 3 database under an ASM on same machine.Each db has 2 disk group's. Db Name :DT6 DT6_DATAGROUP01/ DT6_REDOGROUP01/ Db Name :DT7 DT7_DATAGROUP01/ DT7_REDOGROUP01/ Db Name :DT8 DT8_DATAGROUP01/ DT8_REDOGROUP01/ How these datbase instance correctly identify the diskgroup? Can we use two database instance for One diskgroup? Thanks Regards, VN ## DB:2.32:Mutliple Db In Asm 9z What you cannot control is other DBA's doing silly things like ex: in DT6 -- alter tablespace add file '+DT7_DATAGROUP01' • RELEVANCY SCORE 2.32 ## DB:2.32:Multiple Listeners For Mcod? 9z Hi! If I have more than one DB in MCOD, do I need more than one listener so that each DB has its own listener? Thanks! ## DB:2.32:Multiple Listeners For Mcod? 9z It's up to you. If you want only 1 listener make sure that both instances are contained in the tnsnames.ora file. Make sure the user-ids/groups are correct. If you want 2 listeners running you can do this as well - see Note 153835 • RELEVANCY SCORE 2.32 ## DB:2.32:How To Access Two Oracle Data Base With Out Db Link 8a Hi, I have two data base schema one is held in oracle 10g and the other in 11g ,Currently i am using DB link to access both the database. i am accessing around 70 tables using DB link. As per new requirement i have to remove DB link ,is there any other way i can access both database with out DB link. Thanks, ## DB:2.32:How To Access Two Oracle Data Base With Out Db Link 8a malarkandy wrote: I have two data base schema one is held in oracle 10g and the other in 11g ,Currently i am using DB link to access both the database. i am accessing around 70 tables using DB link. As per new requirement i have to remove DB link ,is there any other way i can access both database with out DB link.Yes. But that needs another network and application interface instead of a database link. The target database can implement PL/SQL web services. These can be called via HTTP. The local database can use UTL_HTTP to make a call to the target database's web service for accessing target database data. Both databases can use AQ (Advance Queues). This can be integrated with an application server's JMS queues. This enable one database to enqueue a request to the other database, and for that database to respond by sending data. There are numerous such type of interfaces that can be used. Some primitive. Some advanced. Some simple. Some complex. The easiest and most flexible mechanism is however a database link. And it does not make sense to disallow database links for security and management reasons, but allow JMS for example. The network infrastructure is the same for both methods. The network protocol is the same. The security issues and concerns are the same - except that JMS for example is significantly more moving parts and make configuration and security a lot more complex than using a database link. • RELEVANCY SCORE 2.32 ## DB:2.32:Procedure Call From Db Adapter: Performance Consideration 1s Hello All, I have a question related to DB Procedure call from DB Adapter. If we call a DB procedure having one RECORD TYPE(100 Columns) as an IN parameter from DB Adapter.. and we call another DB procedure having 100 IN parameter from DB Adapter.. Which performance would be better and why? Thanks, AB ## DB:2.32:Procedure Call From Db Adapter: Performance Consideration 1s Hello All, I have a question related to DB Procedure call from DB Adapter. If we call a DB procedure having one RECORD TYPE(100 Columns) as an IN parameter from DB Adapter.. and we call another DB procedure having 100 IN parameter from DB Adapter.. Which performance would be better and why? Thanks, AB • RELEVANCY SCORE 2.32 ## DB:2.32:Sql 2000 Db To Sql 2005 Db d7 Question: How does one determine if a SQL 2000 DB has already been converted to SQL 2005 DB ? Thanks in advance ....... ## DB:2.32:Sql 2000 Db To Sql 2005 Db d7 For sure, definitely can't go backwards once the database has been restored to 2005. I was just saying that the lower compatibility level is usually a sign that the database was restored from an original 2000 db, and you won't get the functionality of some of the features in 2005. However, since you can change compatibility level, it's not a sure fire way to tell. I definitely agree that once the database is ported to 2005 there is no going back. • RELEVANCY SCORE 2.32 ## DB:2.32:Multiple Db Connections In Session Level m1 HI, I have to load into two targets one in DB2 and other in Oracle. For this targets i have individual DB connections. But in Sesion there is a property under config objects-Error Handling-Error Log DB Connection. Here I want to give both DB connections ,DB2 and oracle .How to give it? Error Log DB Connection:DB2_connection,Oracle_Connection will this work? any suggestions!!!!!!!!!!!!!!!!!! Thanks in Advance, Naveen Kumar C ## DB:2.32:Multiple Db Connections In Session Level m1 It wont work . Give your DB2 connection and then create a mapping which will write the data from DB2 error log table to oracle table. just out of curiosity --why do you want to write same error information in to different databases. • RELEVANCY SCORE 2.32 ## DB:2.32:Errors In Reporting Db 3a Hi everyone! A few days ago I have found some troubles with synchronization DB Published and DB Reporting. Some Data are different in this two DB. I tried to begin rebuild for Reporting DB, but reporting database refresh stuck in waiting to be processed (sleeping). I have found discussion of the same troubles, but no one of them ware resolved. I have no idea what to do. ## DB:2.32:Errors In Reporting Db 3a It looks like there is a permission issue for the account that is used to refresh the RDB. Make sure the account has db owner permissions on these databases.----- PWA:http://ddsm-prj2010/PWA, ServiceApp:PWA, User:DIGDES\Kramarev.A, PSI: [RDS] ULS Event: ReportingRDBRefreshMessageFailed was associated with exception: System.Data.SqlClient.SqlException: Cannot open database ddsm-prj2010_Reporting requested by the login. The login failed. Login failed for user 'DIGDES\ddsm_prj2010_fa'. ----- Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com • RELEVANCY SCORE 2.32 ## DB:2.32:Sqlite Db Not Packaged With Apk 9a Hi, I've a local db which I'm packaging with my mobile application (keeping the db in the project root). I've also ensured that the db file is checked in "Export Release Build" dialogue window's "Package Contents" tab. When for iOS packaging the db packaged within as expected, but when packaging for APK, the db simply not packaged within, file size also demonstrating that (one is 46 MB where APK is 3.5 MB, db is large). I'm not sure why its not packaging for Android build; any help would be very appreciated. Thank you. ## DB:2.32:Sqlite Db Not Packaged With Apk 9a Hi, I've a local db which I'm packaging with my mobile application (keeping the db in the project root). I've also ensured that the db file is checked in "Export Release Build" dialogue window's "Package Contents" tab. When for iOS packaging the db packaged within as expected, but when packaging for APK, the db simply not packaged within, file size also demonstrating that (one is 46 MB where APK is 3.5 MB, db is large). I'm not sure why its not packaging for Android build; any help would be very appreciated. Thank you. • RELEVANCY SCORE 2.32 ## DB:2.32:Fvl328 And Subdomain? z3 I am running a single static IP at my office. I have several PORT FORWARDS setup withing my SERVICES tab. Of course, under my RULES tab I have all the different services going to the different computers, or several of the services going to the same computer. I am in a bit of a pinch since I have a need to setup a WEBUPLOAD for my office and I no longer wish to use the port forwarding, as I am being told that if I were to simply use a subdomain, it would work basically the same, and it would look a little more professional. For example, webupload.domain.com would come into my IP address in my office and my router would send that 'webupload' to a specific computer. Can such thing be done with this FVL328 router? If so, could you please tell me how. I would GREATLY appreciate it. Thanks in advance, Alex ## DB:2.32:Fvl328 And Subdomain? z3 • RELEVANCY SCORE 2.31 ## DB:2.31:How To Monitor Db Server Cpu Utilization And Iowaits In Ssm? 79 Dear Gurus, Our SAP PRD system consist of one CI, 3 DI and an Oracle DB (pls seee screenshot below). DB installed on a stand-alone server. Now we want to use SAP Solution Manager to monitor our entire SAP landscape (including DB). But I don't know how to get DB server's CPU Utilization and IOwaits? Can I use CCMS to do it? Best Regards! Jason ## DB:2.31:How To Monitor Db Server Cpu Utilization And Iowaits In Ssm? 79 Dear Gurus, Our SAP PRD system consist of one CI, 3 DI and an Oracle DB (pls seee screenshot below). DB installed on a stand-alone server. Now we want to use SAP Solution Manager to monitor our entire SAP landscape (including DB). But I don't know how to get DB server's CPU Utilization and IOwaits? Can I use CCMS to do it? Best Regards! Jason • RELEVANCY SCORE 2.31 ## DB:2.31:Couldn't Find Sample Schemas (Oe, Hr) In The Html Db xp Hi, my 10gR2 database running on Red Hat AS Linux 3.0, with HTML DB 1.6 installed. I try to create a "oe" HTML DB workspace by using existing "oe" schema, but there is no such one could be found inside HTML DB, any clue how to make this "oe" schema available to HTML DB? Thanks. ## DB:2.31:Couldn't Find Sample Schemas (Oe, Hr) In The Html Db xp the users OE and HR may be locked, unlock them first, do it via OEM or execute UNLOCK user from SYSTEM/SYS. • RELEVANCY SCORE 2.31 ## DB:2.31:Db Size 3x HI I have Development database now we move devlopment db to production db so i want to forecast my db size How i calculate my Total System Global Area,Fixed Size,Variable Size,Database Buffers,Redo Buffers value. Is any formula is available in Oracle Please any one help me ## DB:2.31:Db Size 3x Don't take my previous post wrong. What was my mind is the number of objects was not directly involved in the database size. 1,000,000 of objects may have less "weight" than 1,000 objects, depending of what we tell about. Nicolas. • RELEVANCY SCORE 2.31 ## DB:2.31:Delayed Write Failed Error When Uploading Large Pdfs With Embedded Images cd We're having some issues here where we cannot upload PDF files that are comprised of scanned images. Forefront is deleting the file during the upload process. If you are using the typical webupload interface, you get an error message saying that file cannot be found (because it's been deleted, presumably). If you try dragging and dropping in the Windows Explorer mode, you get this error message: In one case, the PDF had about 420 pages in it. We split the PDF into two files, one with 200 pages and the other with the remainder, and it worked fine. In both cases, the original file size and the new file sizes were well under the maximum file size limit (the original file size was only 8MB). I'm suspecting that this issue is somehow related to a similar bug with large zip files and how Forefront can choke on large compressed files. Although the PDF is not a zip, it is a container that is holding images which contain no text to scan, or something? Anyone else experience this issue or know of a setting to fix this? Thanks, Eric ## DB:2.31:Delayed Write Failed Error When Uploading Large Pdfs With Embedded Images cd Thanks, Yuri. Upon further investigation, this was actually an IIS 7 issue with maximum upload sizes. I was able to fix this by changing the maximum upload settings in IIS 7 and by making the related web.config changes in the SharePoint web apps, and that cleared up the issue. The PDF -- OCR issue was a false positive because it was really just shrinking the file size, it wasn't a PDF or compressed file issue at all. This article addressed those issues:http://support.microsoft.com/kb/925083 • RELEVANCY SCORE 2.31 ## DB:2.31:Connect To External Db From Jsproc Using Jdbc xp I need connect two db with java, using a Java Stored Procedure stored in one of these db. How can I connect the other db? I have used jdbc, but it is necesary that a Oracle Server run the jdbc client drivers to access the other db. It is possible??? Please help me... ## DB:2.31:Connect To External Db From Jsproc Using Jdbc xp How can I access to the jdbc drivers(8.1.6) from a Oracle8i(8.1.5)? • RELEVANCY SCORE 2.31 ## DB:2.31:How To Connect Oracle 11g To Nodejs ? xk hi when i want to connect to oracle with node.js , i use this article on this link https://github.com/mariano/node-db-oracle , when i want to install db-oracle with " npm isnatll db-oracle " , the error in below is shown : npm install db-oraclenpm http GET https://registry.npmjs.org/db-oraclenpm http 304 https://registry.npmjs.org/db-oracle db-oracle@0.2.3 install /opt/instantclient/node_modules/db-oracle node-waf configure buildsh: node-waf: command not found db-oracle@0.2.3 preuninstall /opt/instantclient/node_modules/db-oracle rm -rf build/*npm ERR! weird error 127npm ERR! not ok code 0can any one help me ?thanks ## DB:2.31:How To Connect Oracle 11g To Nodejs ? xk db-oracle has not been updated for 2 years, please, use node-oracle instead - https://github.com/joeferner/node-oracle • RELEVANCY SCORE 2.31 ## DB:2.31:Find Out Db k3 Hi TEam We have one Server in that server XXX DB is there but here n no DB's is there could you plz suggest me any query to find out this DB and where i have to server for DB can u sugest me Tx subu ## DB:2.31:Find Out Db k3 Select * from sys.databases where name like %XXX% • RELEVANCY SCORE 2.31 ## DB:2.31:"Xml Db" Included In Xe ? da Is "XML DB" Included in XE ? If yes, is it any different from the one in 10gR2 EE ? thanks ## DB:2.31:"Xml Db" Included In Xe ? da When you open http://10.10.10.12:8080/ as a webdav folder via Internet Explorer, then you will see all the toplevel folders there. Then you can also drag drop static files there. Very convenient to exchange files in a collaborative project. File Open enter http://10.10.10.12:8080/ and check "Open as web folder". Then enter the credentials for the oracle user SYSTEM. Looking at http://10.10.10.12:8080/ through the "normal browser" you will get to the default index html page showing you the license information. Regards, ~Dietmar. • RELEVANCY SCORE 2.31 ## DB:2.31:Does Db First Farmework Supports Poco Objects , If So Can Some One Explain In Details f7 does DB First farmework supports POCO Objects , if so can some one explain in detailstest ## DB:2.31:Does Db First Farmework Supports Poco Objects , If So Can Some One Explain In Details f7 Hi suren1234, You can refer this link: http://blogs.msdn.com/b/adonet/archive/2010/01/25/walkthrough-poco-template-for-the-entity-framework.aspx I suggest you to use Code First: http://blogs.msdn.com/b/adonet/archive/2011/09/28/ef-4-2-model-amp-database-first-walkthrough.aspx Have a nice day.Alan Chen[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help. • RELEVANCY SCORE 2.31 ## DB:2.31:Is Migration Possible From One Oracle Db To Another Oracle Db? am Is Migration possible from one Oracle DB to another Oracle DB? Thanks Mahesh ## DB:2.31:Is Migration Possible From One Oracle Db To Another Oracle Db? am this is not a migration, but an upgrade. for upgrading the database you should try first Database Upgrade Assistant, shipped with all the releases. make sure you made a full backup before upgrade, just in case. andrei • RELEVANCY SCORE 2.31 ## DB:2.31:Reg Materailized Views -- One Source Two Destinations || Doubt zk Dear All, We have created Materialized Views for 8 tables of a remote DB ( say DB-Source) to our DB (say DB-1) and created some procedures and the whole setup is working fine. Now, we have another DB (say DB-2) which requires the same 8 table of DB-Source to run similar procedures. I got a doubt here. All the modifications at DB-Source are captured in MVlogs and when the DB-1 refreshes the MViews, the logs will get cleared. In this scenario, how can the DB-2 uses the same the modified data from DB-Source (if the MVlogs are cleared by the refresh of DB-1)? I jsut want to know whether one source of tables with MVlogs can cater it services to two DBs with the same modified information. Kindly suggest. Regards Deep ## DB:2.31:Reg Materailized Views -- One Source Two Destinations || Doubt zk Hi, No problem. MVLOG has Both data DB-1 and DB-2. Check DBA_REGISTERED_MVIEWS view. Regards, • RELEVANCY SCORE 2.31 ## DB:2.31:Db Link Is Linkable To Remote Db's View ? cc We use Oracle 11gr2.we use DB link. DB link is linkable to remote DB's view ?One of our DB link became to be not working fine and we found that when that time some public synonym are deleted in remote DB.I would like to know this Drop synonym is cause of malfunction of that DB link. ## DB:2.31:Db Link Is Linkable To Remote Db's View ? cc That would mean that either the database link or the the network connection identifier for the Database Link could not be found. For example if the database link has been created as "create db_link connect to username identified by password using 'remote_DB';" you must check if the network connection string for "remote_DB" -- typically in the local database server's$ORACLE_HOME/network/admin/tnsnames.ora file.Hemant K Chitale

• RELEVANCY SCORE 2.31

## DB:2.31:One Of The Db Is In Suspect Mode ..How Can I Put Online am

hello all
one of my server one db went in suspect mode and another one is inrecovery_pendingmode..
how can get back these db to online..............

Environment is sqlserver2005 sp2

## DB:2.31:One Of The Db Is In Suspect Mode ..How Can I Put Online am

Hi
Once again i would like to highlight the important message. Never alow passenger to pass through a sinking boat. We need to ensure that the enviornment is stable .
First we need to understand and find why it went to suspect modfe first. Without this clue even if we give commands to bring it onlie(Hopefully) there is no guarantewe that it will go back to suspect mode again.
'REPAIR_ALLOW_DATA_LOSS is a crucila part which might lead to logical inconsistency. I am not suer whether we can anticpate such data loss in a airtraffic system, Banking (or) Medicare(hospitals) .
Knowing about what kind of data is stored in the database is crucial.
By the way When Microsoft send a recommendation to a rebuild log they will Be seding a DISCLAIMAR to get agreed first of runing the above command which is not dicussed here in detail.
I wanted to ensure that your doing the right thing to avoid any surprises later.
If you just need a online answer then this is what mine would be.
If the dataase is configure for full recovery. and assuming you have TLOG backup taken earlier.then this is the step to bring it online.
For Clean restore (Option 1)
===================
1) Take database to emergency mode
2) Take tail TLOG BACKUP (Assuming TLOG is not corrupted)
3) Restore database from last known good backup
4) restore All tlogs in the same order.
5) Restore the Tail log backup taken in step2.

For Restore with Data Loss (Option 2)
===================
==Proceed with Deba basu recomendation

No backups and Dont want to have huge data loss(Option 3)
=======================================
1)==Proceed with Deba basu recomendation (except executing the repair_allow_data loss)
2) script out the existing database and create a new dumy database.
3) export the data from the emergency database to the new database.

Note : If you can provide me about the enviornment details and the applicaiotn_log , system event log , sql errorlog covering the problematic time when it went to suspect mode i can review it and provide you some guideliness.
Regards

Davidmgopal
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

MCTS/MCITP (SQL Server 2005, 2008, 2005 BI)

• RELEVANCY SCORE 2.31

## DB:2.31:Query To Get The Current Db Date, Not Server Date 8d

Hi,We have few DB in one server, but each DB have different timezone.How can I get the query to generate the current date in each DB?Thanks

## DB:2.31:Query To Get The Current Db Date, Not Server Date 8d

Hi,Try this query:SELECT DB_NAME() AS DataBaseName,getdate()Thanks Regards,Nagarajan

• RELEVANCY SCORE 2.30

## DB:2.30:Constraints In Timesten Db pa

Hi ,

Can any one post the query for list out the constraints on a table(Timesten DB) ?

Thanks,
Praveen.

## DB:2.30:Constraints In Timesten Db pa

and look for the create table section

• RELEVANCY SCORE 2.30

## DB:2.30:Ascp Instance Setup - Db Link Creation In Decentralized Configuration d8

I came across this question on setting up the APS for decentralized configuration and really couldn't find why? The question was why do we need to create two DB links (One in Source for destination db and other one in destination for source db) and can we setup ASCP instance by creating only one DB Link, either at destination or at source?

Thanks

## DB:2.30:Ascp Instance Setup - Db Link Creation In Decentralized Configuration d8

This screen only provides visibility to currents supply/ demands in execution system and doesn't reflect any planned supplies/ demands suggested by ASCP Plan. Thus while its good place to find most updated picture of actual supplies/ demands on shop floor, it'll only be an incomplete picture if you don't account for anticipated supply/ demands in near future.

• RELEVANCY SCORE 2.30

## DB:2.30:How Can I Duplicate A Document Print Layout From One Db To Another Db? 99

hi experts,

I make all document print layouts in a test DB, and now I want to move them to my production DB.

is there any easy way to copy a document layout from a database to another? please advise, thanks a lot.

## DB:2.30:How Can I Duplicate A Document Print Layout From One Db To Another Db? 99

Hi

Is there any error you are getting while using the Copy express Addon

Thanks

• RELEVANCY SCORE 2.30

HiIs it possible to add a new format say .db in documentum. presently to my knowledge i did not find any file format with db extension in Documentum. we have one requirement where in we have to store files with format .db(database) in the docbase. can some one throw some light to it

Is it possible to add a new format say .db in documentumYescan some one throw some light to itcheck this support note for creating new formatshttp://softwaresupport.emc.com/support/resolutions/dmfrmresolutionview.asp?id=3060

• RELEVANCY SCORE 2.30

## DB:2.30:Db Links And Security d9

DB Version:10gR2

To connect to a remote DB, we create only one DB link for that DB. We create a public DB Link like

connect to SYSTEM identified by jklf
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.16.314)(PORT = 1521))
)
(CONNECT_DATA =
(SID = wmat)
)
)';Since we are connecting as SYSTEM user of the remote DB, we only have to prefix the remote schema name and access the DB object over there.
But, isn't this a security threat for that remote DB since we are connecting as SYSTEM over there?

Question1.
If you did a security Audit in these two DBs, what would you say?

Question2.
Is creating a DB Link for every schema or one DB link connected to the SYSTEM (as mentioned above) of the remote DB the standard practice?

## DB:2.30:Db Links And Security d9

I would also recomend that the db link connects to a user whihc only has appropriate permissions on the required objects.

• RELEVANCY SCORE 2.30

## DB:2.30:Very Large Db Migration j1

Can we consider to realign two Oracle DB (same version) between two machines (NT and UNIX) using the archive log of NT for the UNIX DB (the data were imported in UNIX with the NT DB export one week in advance) ?
In other words are archive log platfom independent ?

## DB:2.30:Very Large Db Migration j1

Can we consider to realign two Oracle DB (same version) between two machines (NT and UNIX) using the archive log of NT for the UNIX DB (the data were imported in UNIX with the NT DB export one week in advance) ?
In other words are archive log platfom independent ?

• RELEVANCY SCORE 2.30

## DB:2.30:Db Links Related Wait Event 1f

Dear,In one of my db , i use db link to generate report from another db. The db in which we use dblink for remote databases ; the following wait events are continuously showed up:PX Deq Credit: send blkdPX Deq: Execution MsgSQL*Net message from clientAre they indicating to any problem?? How can we get rid of it???Regards,

## DB:2.30:Db Links Related Wait Event 1f

Hiwhich parameter should you concerned , for this purpose , i sguuest you to read below link .http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-parallel-execution-fundamentals-133639.pdfRegarding the sufficient default value , depends up on many factors like memory, resource , cpu , data volume, optimizer which can not be sufficient some times when set at default values .RegardsShivendra Narain Nirala

• RELEVANCY SCORE 2.30

## DB:2.30:Backing Up Oracle Db For Fms 7j

Hi,

I have installed Fabric Manager Server v3.2(2c) using the Oracle DB option. Backup of this DB can be done in either Online (ARCHIVELOG mode) or offline (NOARCHIVELOG mode).

In one of the ccokbooks i found the Oracle DB holds inventory, fabric configuration and states of the ports.

How critical is a backup of this DB if i'm not using Performance Manager? (I believe PM stats are also held in this DB). If this DB becomes corrupted what are the consequences?

## DB:2.30:Backing Up Oracle Db For Fms 7j

Hi Mike, here are the steps which I have utilized for restoring performance data to a new FMS/DB install:

Migrating Performance Data from prior Installation

Stop Fabric Manager Server

Copy the existing RRD files (from a prior install to cisco\mds9000\pm\db

run the cisco\mds9000\bin\pm.bat

Restart Fabric Manager Server

Add Fabric to be managed back into Fabric Manager through web interface

Edit new Fabric and set to Manage Continuously through web interface

Add the fabric to the Performance Manager collections through web interface

Historical data should now be available

• RELEVANCY SCORE 2.30

## DB:2.30:One Nt Account To Authenticate And Connect To Both Cms Db And Audit Db. f7

All:

Please, could you confirm than one NT account for the CMS to connect to both CMS DB and AUDIT DB (running on SQL server DB) is recognized as a good strategy?

-Usually, we advise to use 2 DB accounts, one to connect to the CMS DB and one to connect to the Audit DB.

-In our case, the CMS is using NT authentication (through the ODBC driver), so there is no way to specify 2 DB accounts to connect to the 2 schemas.

-Gabriel

Gabriel de LAPPARENT, BOCP-BOE

Senior Engineer

SAP America, Inc.

## DB:2.30:One Nt Account To Authenticate And Connect To Both Cms Db And Audit Db. f7

1 account is fine, we consolidate all the time from older docs that used to indicate more than 1.

The primary advantage of using multiple is that when logging on the DB, or other you can see which process is hitting it. Since only yhe CMs would hit either the CMS DB or auditing DB then it really shouldn't matter.

Regards,

Tim

• RELEVANCY SCORE 2.30

## DB:2.30:Bt Cloud - No Web Upload Button j1

Just started to use bt cloud , can log in ok , but no webupload buttonon the top i have a "add to bt cloud sync"

Useing ie and windows 8

## DB:2.30:Bt Cloud - No Web Upload Button j1

Ribblelancs said...{The point I'm trying to make is that the "add to sync" command when not in the sync folder is not correct.}You cannot make a folder that is outside the Sync. The folders that were created as device folders are [now] inaccessible.I genuinely ask if I am I 'missing' (literally) something here?

• RELEVANCY SCORE 2.30

## DB:2.30:Import Db c7

tell me the DBscript command to change the schema names in the DB dumpfile while importing DB from one system to the other system (oracle 10g)

## DB:2.30:Import Db c7

tell me the DBscript command to change the schema names in the DB dumpfile while importing DB from one system to the other system (oracle 10g)

• RELEVANCY SCORE 2.30

## DB:2.30:Db Error After Upgrade 9z

When I try to click any db for any domain I get an error like this one: Error: Object not found: Database #409 users

And if I try to create a ned db, I have no options to select from in the db type list.

I asume those problems are connected, but I cn not figure out what the problem is... Any help would be apresheated.

## DB:2.30:Db Error After Upgrade 9z

I cant rmemeber exactly what I did, but I think I had to add the local mysql database server to plesk. Then I got an error on access wich was resolved by alering my hosts file so that 127.0.0.1 got the correct host for the mysql database. (I cant remember if it needed localdomain.localhost or just localhost, mine where set up oposite of what plesk 8 needed.)

• RELEVANCY SCORE 2.30

## DB:2.30:Jspdynpage Having Db Connection ja

hi all

i created one jspdynpage application having db connection

but i got so many errors

in that

can any one send par file to me

having jspdynpagejspdbconnection

## DB:2.30:Jspdynpage Having Db Connection ja

can u send the code JspDynpagejspBAPI

• RELEVANCY SCORE 2.30

## DB:2.30:Rules sf

Can any one tell me how to store Rules in DB and get them from DB?

## DB:2.30:Rules sf

You have posted a lot of messages to this thread, which makes it hard to determine what question to answer.
If you are concerned about deserializing the rules repeatedly, you can consider caching them in-memory such as described here:
http://msdn.microsoft.com/en-us/library/dd349785.aspx

• RELEVANCY SCORE 2.30

## DB:2.30:Cleardb Delete Db And Recreate Fails Because I Am Allowed Only One Instance j8

My word press DB got corrupt because of bad config entryi added in there.

my only option was to delete and recreate the site and the db. but now the DB creation fails because i am allowed only 1 MySQL db from cleardb even though i have already deleted my existing one.

any ideas what to do here.?

thanks
Sudha

## DB:2.30:Cleardb Delete Db And Recreate Fails Because I Am Allowed Only One Instance j8

I had the same problem; here's what I did to fix.
1. Create a new empty website with NO database
2. Once created, go to Linked Resources tab and select the previously created DB as a linked resource
3. Now, delete the empty website but make sure you have checked the box to delete the linked resources

Once that has completed you can create a new wordpress site with a new database.

• RELEVANCY SCORE 2.30

## DB:2.30:Replicating A Primdb Onto Two Repdb, And One Table Of Same Primdb Onto A Second Repdb, Changing Tbname cf

We have that situation:

One Ase Primary Database Srv-P1 DB-1

Two Ase ReplicateDatabases Srv-R1 DB-1

Srv-R2 DB-2 TB-ARC
The obective was to:

replicate all from Srv-P1:DB-1 to Srv-R1:DB-1

replicate A SpecificTable from Srv-P1:DB-1(TB-DEV)

to Srv-R2:DB-2(TB-ARC)

Of course, (TB-ARC) asa different name as (TB-DEV)

also, 'DELETE' arenever replicated into (TB-ARC)

We created two RepDef: database replication definition 'dd1'

table replication definition 'td1'

and two Subscr: 'ds1' mapped to 'dd1' replicatingSrv-P1:DB-1 into Srv-R1:DB-1

'ts2'mapped to 'td2' replicating Srv-P1:DB-1(TB-DEV) into Srv-R2:DB-2(TB-ARC)

The problem is when weare inserting a row into Srv-P1:DB-1(TB-DEV)

That should bereplicated in two places.

The replication iscorrectly done by TableRepDef and Subscription 'td2'ts2' wher the 'mdl'produced into de 'dsi' has been modyfied by the RepDef to fitt into Srv-R2:DB-2(TB-ARC).

Curiously, thereplication process try to replicate the same MDL into Srv-R1:DB-1(TB-ARC).

(TB-ARC) Table does notexist Srv-R1:DB-1;it exist only on Srv-R2:DB-2

The 'dsi' forSrv-R1:DB-1 is shutting down with an error.

If we replace theDatabase Replication Definition 'dd1' and is subscription 'sd1' by a set ofTables Replication Definition and subscription for alle the Tables ofSrv-P1:DB-1, every goes well.

Each insert intoSrv-P1:DB-1(TB-DEV) is replicated into Srv-R1:DB-1 and Srv-R2:DB-2(TB-ARC)

Each insert intoothers Tables of Srv-P1:DB-1(TB-DEV) is replicated into Srv-R1:DB-1

## DB:2.30:Replicating A Primdb Onto Two Repdb, And One Table Of Same Primdb Onto A Second Repdb, Changing Tbname cf

Dennis -

It was a bit hard to read the above due to formatting....and unfortunately, I don't speak French so some of the output that was attached was a bit beyond me....and the big issue was that the output didn't have the repdef RCL in it - which is the key part of the problem here. However, I think I know what you are trying to do and wonder if you did it correctly. What you should have done:

...let's assume we have a table named trades that in TB-ARC we want called trade_hist....

1) create repdef1 using the all tables clause with table named trades

2) create repdef2 using the primary table named trades and replicate table named trades_hist syntax

3) for the DSI connection to TB-ARC set the dsi_command_convert to d2none.....make sure you do this just for that connection (alter connection) vs. changing at the server level.

4) subscribe to repdef1 at the Srv-R1:DB-1

5) subscribe to repdef2 at TB-ARC

In the future, please provide ALL RCL scripts - specifically repdefs, subscriptions and any function string changes you have made.

Thanks!

• RELEVANCY SCORE 2.30

## DB:2.30:"Sales Contract" Master Data Tables (Db Tables) In Crm Sap zm

Can any one please tell me the "sales contract" db tables and master data tables for header and item level details in CRMSAP .

## DB:2.30:"Sales Contract" Master Data Tables (Db Tables) In Crm Sap zm

Can any one please tell me the "sales contract" db tables and master data tables for header and item level details in CRMSAP .

• RELEVANCY SCORE 2.30

## DB:2.30:How To Copy Table Data From Onde Db To Another Db Using Clipboard s7

HI,

i copied table data from one DB to another DB, but it displays an error as "policy with check option violation" when inserting the table data.. so how to resolve the proble.. thanks in advance.

## DB:2.30:How To Copy Table Data From Onde Db To Another Db Using Clipboard s7

I already explained to you what causes that error, and if you read the documentation you'd find the same information.if you don't understand what vpd is or what that specific error means, I suggest you read the docs or discuss with someone with whom you work.

• RELEVANCY SCORE 2.29

## DB:2.29:I Have One Db Server And One Web Frond End Server With Sharepoint 2010? Power Pivot Should Be Installed In Db Server Or Web Front End Server? a7

Hi All
I have one DB server and one Web frond end server with sharepoint 2010? Power pivot should be installed in db server or web front end server?

Ravi

## DB:2.29:I Have One Db Server And One Web Frond End Server With Sharepoint 2010? Power Pivot Should Be Installed In Db Server Or Web Front End Server? a7

Rave,
http://technet.microsoft.com/en-us/library/ee210616(v=sql.105).aspx
look at the information about analysis services, make sure you handle that to the letter, read through this entire post, versus the tempting bolded text, and you should be in business.Stacy Anothersharepointblog.blogspot.com

• RELEVANCY SCORE 2.29

## DB:2.29:Snapshots Initial,Minextents,Maxextents. The Same Values As In Master Db? 78

Hi Folks,

I have one question. Need to generate one snapshot in a snapshots-DB.

Should they have the same storage data (initial,minextents,maxextents) as in the master db?

Tnx.

Cheers
Romi

## DB:2.29:Snapshots Initial,Minextents,Maxextents. The Same Values As In Master Db? 78

Hi demorgan,

I didn't say that a oracle is a microsoft product. We have Oracle 10g under Linux.

Yes, we have two separate daatbases. One with the "normal" data and another only with the snapshots. This snapshots are refreshing over one db job every 2 minutes.

For example I want to create one snaphot in this report database with this query:
create snapshot SNAPSHOT_NAME
storage(initial X minextents Y maxextents Z )
tablespace DATA_TABLESPACE
using index tablespace INDEX_TABLESPACE
refresh fast with rowid as select * from SCHEMA_USER.TABLE_NAME@LINT_TO_MASTER_DB;

My question is: X,Y,Z (initial X minextents Y maxextents Z) needs to be the same as a table in master db (database with a normal data) or can I defined them as i want?

Cheers,
Romi

• RELEVANCY SCORE 2.29

## DB:2.29:Data Partitioning Option In Oracle Db Se One jz

Is it possible to activate data partitioning option in Oracle DB SE One 10.2.0.1.0?

## DB:2.29:Data Partitioning Option In Oracle Db Se One jz

No. Partitioning is an Enterprise Edition Option, available only as a paid add-on to an Enterprise Edition Licence.

• RELEVANCY SCORE 2.29

## DB:2.29:Psa Db Missing Or Deleted..... fz

Hi Sergius
I am using PLESK 8,30 in my one server and 1 year testing this software.
Esterday i restarting server and see PSA db not preset in MSSQL server and db northwind, I am repair instalation, complet reinstall PLESK and psa not preset and not exist.
In backup this db not update. I dont understand where is problem. In my PLESK run only one domain my license is unlimited domain . In this server not hosting domain and pages, not viruses, not mail services. In MSSQL server run only this DB

## DB:2.29:Psa Db Missing Or Deleted..... fz

ally said:

• RELEVANCY SCORE 2.29

## DB:2.29:One More Bug In Db Tools ak

Hello AllYet another bug in DB toolset.The "defined size" is exchanged with "actual size".file: Rec Get Column Properties (R).viunder file:DB Tools List Columns.vi See enclosed pictures.It is enough to change two input to bundle to fix the problem.regardsPawel

Attachments:

db_tools_bug.gif ‏16 KB

## DB:2.29:One More Bug In Db Tools ak

Hello AllYet another bug in DB toolset.The "defined size" is exchanged with "actual size".file: Rec Get Column Properties (R).viunder file:DB Tools List Columns.vi See enclosed pictures.It is enough to change two input to bundle to fix the problem.regardsPawel

Attachments:

db_tools_bug.gif ‏16 KB

• RELEVANCY SCORE 2.29

## DB:2.29:Roll Back And Retry In Db Adapter... ff

Hi All,Can any one help me on HOW TO ROLL BACK AND RETRY IN DB ADAPTER......Thanks in advanceShree

## DB:2.29:Roll Back And Retry In Db Adapter... ff

Hi Abhijit,Thanks for your reply.Can you help me in this 1. What is logical delete and in which case we need to use it?2.Can you tell something about inter dependencies3.Can we use Fault polices/bindings in sequential loading?Thanks in advance

• RELEVANCY SCORE 2.29

## DB:2.29:Xml Db Repository ap

Hello,
How does one navigate the xml db repository? I am told I can view its contents in internet explorer. How does one do that?
Julien Martin.

## DB:2.29:Xml Db Repository ap

http://YourHostNameHere:8080

• RELEVANCY SCORE 2.29

## DB:2.29:Xml Db Repository 3p

Hello,
How does one navigate the xml db repository? I am told I can view its contents in internet explorer. How does one do that?
Julien Martin.

## DB:2.29:Xml Db Repository 3p

Hello,
How does one navigate the xml db repository? I am told I can view its contents in internet explorer. How does one do that?
Julien Martin.

• RELEVANCY SCORE 2.29

## DB:2.29:Can I Switch A From A Referenced Oracle Db To Second Oracle Db (Location) ? 9p

During the installation of the SOA suite I referenced an existing first Oracle 10g DB
in say

C:\test\database\ora10.2.0\

Now I plan to de-install this Oracle DB and install another, new one in a different location e.g.

D:\oracle\db\

How can I tell the SOA suite to forget the old DB installation use this new DB in the future ?

Where do I have to change which settings to let SOA suite successfully run with the new DB?

Is there an auto-detect feature built-in ?

## DB:2.29:Can I Switch A From A Referenced Oracle Db To Second Oracle Db (Location) ? 9p

You need to re-allocate the database-schema's that have been installed on your new database. The best to do this is to re-install the schema's oraesb, orabpel, ... using the obant script and then your application server will point to the new database location.

If you're going to use a clean installation, in other words an empty db instance it would be easier to just install the schema's again and then map your application server to those schema's.

Kind regards,
Nathalie

• RELEVANCY SCORE 2.29

## DB:2.29:Regarding Server Patterns 7c

HI guys,Could you guys tellme what are the Merits and demerits in installing SAP/DB in different pattern as follows1) SAP/DB in one box2) ABAP/DB in one box and JAVA/DB in another box3) Installing all instances(CI/DI etc) seperately Have any document related to this..explaining about thisregardsChandra

## DB:2.29:Regarding Server Patterns 7c

thanks

• RELEVANCY SCORE 2.29

## DB:2.29:Sqlite Db In Bb 10 mf

Iam developing an app with SQlite as db.Is this possible in bb 10 cascades.I didnt find any usefull link where i can start with Sqlite db creation.(Create tables to db,how to get data from db,how to set data to db).Can any one plz help me

Solved!
Go to Solution.

## DB:2.29:Sqlite Db In Bb 10 mf

Yes, SQLite is used in that sample. That sample create db before and copy to the data folder.If you want to create table at runtime, you can use this

When your application start call this

Feel free to press the like button if I helped you in solving your problems.

• RELEVANCY SCORE 2.29

## DB:2.29:Md5 Migration Issues Using Different Character Set xa

Hi,

DBname = test1 , db charcter set WE8ISO8859P1 ,os charcter set WE8ISO8859P1

DBname = test2 , db charcter set US7ASCII ,os charcter set UTF8

In both DB table1 having encrypted data using md5 encryption techniques . (dbms_obfuscation_toolkit.md5(input_string = v_input) )

Now i want to migrate data from test2 DB to test1 DB .How to migrate any one please help.

Naveen

## DB:2.29:Md5 Migration Issues Using Different Character Set xa

I'm not sure that I follow what you're suggesting but it sounds like you're on the right track.

I'm still not sure whether you need the MD5 hash to match data in the database or not. If you change the character set of the underlying data, the MD5 hash may change so just keeping the hash intact may not be sufficient.

Justin

• RELEVANCY SCORE 2.29

## DB:2.29:Delete Companies And Dbs During A Sl 2011 Upgrade km

I'm upgrading a client from SL 6.0 to 2011. They have 6 application DBs in one SYS DB and 8 companies within MainAPP DB. They only want to upgrade / migrate MainAPP DB and only 1 compmany within the MAINAPP DB. Does anyone have suggestions
on how to delete the other 5 APP DBs and the other 7 companies within the MAINAPP DB?

Thanks,

Colette

## DB:2.29:Delete Companies And Dbs During A Sl 2011 Upgrade km

I'm upgrading a client from SL 6.0 to 2011. They have 6 application DBs in one SYS DB and 8 companies within MainAPP DB. They only want to upgrade / migrate MainAPP DB and only 1 compmany within the MAINAPP DB. Does anyone have suggestions
on how to delete the other 5 APP DBs and the other 7 companies within the MAINAPP DB?

Thanks,

Colette

• RELEVANCY SCORE 2.29

## DB:2.29:Need Advice On Second Db On A 2-Node Rac Already Has A Db cc

We are going to add a new db to a existing RAC 2 node environment.

Currently we have one db on this two node rac ( each node has one instance).

I want to be sure I follow oracle best practice on shared oracle home, shared listener, etc.

Our environment is : db version: 11.2.0.3
os version: redhat 5

what is the best way to prevent node eviction or any complications for a shared oracle home?

Also on the existing db, oracle service created for load balance connection and failover.

If we add a new db, what should I do with the db connection? Should I designate one node for one db or do same failover/load balance services?

Thanks,

## DB:2.29:Need Advice On Second Db On A 2-Node Rac Already Has A Db cc

We cannot consolidate the two db into same db with two different schemas.

• RELEVANCY SCORE 2.29

## DB:2.29:Temp Db x9

Hi,

Can we have multiple Temp DB in one instance

Thanks
Shashikala

## DB:2.29:Temp Db x9

As other say, Only One tempdb per SQL instance is possible. You can not have more then one tempdb on one sql instance.Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.

• RELEVANCY SCORE 2.29

## DB:2.29:Copy A Sql Query From One Db (Located In Views) To Another Db On The Same Server. 9s

Hi,
How can I copy a SQL Query from one DB (located in VIEWS) to another DB on the same server? We have a SQL 2005 server, which has two test databases on it and one production DB. The SQL Query was created in a test DB and located under Views. I want to copy
that query to the production DB.

Thanks!

## DB:2.29:Copy A Sql Query From One Db (Located In Views) To Another Db On The Same Server. 9s

Thanks Darwin! You've been a huge help!

• RELEVANCY SCORE 2.29

## DB:2.29:Shrink Database After Drop Column fs

Hi,
we create monthly a test database(DB) for test purposes from the backup of operational DB.
we have a DB (220 GB) with 600 tables. The size of 2 tables are 200 GB.
the one column in these tables ColumnName varbinary(MAX) has binary data, which we don't need for testing.
therefore after creating the test DB we delete the data in this column.
But the problem is: it takes 8 hours to shrink the DB from 220 GB to 20 GB.
Which command should I use for deleting the data in this column to get a smaller size of DB?
After creating a test DB I can change the DB configuration!
I tried:
DROP COLUMN and SHRINK DB
UPDATE COLUMN SET NULL and SHRINK DB
DROP COLUMN and CLEANTABLE

PS: I do not need the transaction log for test DB

Thanks,

## DB:2.29:Shrink Database After Drop Column fs

Do you have any space problem? Why do you shrink the database? It'll cause no of things.

PS: I do not need the transaction log for test DB
Nope. Every database must have a transaction log file. Think if you don't have log file then how will SQL manage the Consistency and do the commit/rollback.

If the tables have clustered index you can drop column and rebuild it. This will reclaim the space.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers SqlserverBlogForum

• RELEVANCY SCORE 2.29

## DB:2.29:Modifying Db Table 7d

Hi,Im populating the internal table from DB table. and deleting one record from that internal table. and also im changing one record in that internal table. so the same should be updated to DB table also.bie.,/b deleted record should be deleted in DB table and also modified record should be modified in DB table.How i can do this?Regards,Amal

## DB:2.29:Modifying Db Table 7d

hI stephen,use modify db tab name while looping the valies from itab.reward if useful.kishore

• RELEVANCY SCORE 2.29

## DB:2.29:Opening Db In Exclusive Mode xk

If I have a backend DB and several Frontend DB, can i open the backend DB in exclusive mode?
Sometimes I’m having issues opening the backend DB in exclusive mode, and i know no one else has the backend open?

## DB:2.29:Opening Db In Exclusive Mode xk

You need to make sure that your frontend (nor anyone else's)is not open or else you won't be able to open the backend as exclusive.

• RELEVANCY SCORE 2.29

## DB:2.29:How To Change Jndi Dynamically In Db Adapter And Ftp Adapter 8s

Hi every one,

Please any one explain "How to change JNDI dynamically in DB adapter and FTP adapter" with screen shots

## DB:2.29:How To Change Jndi Dynamically In Db Adapter And Ftp Adapter 8s

Please raise this as a separate thread. The idea is to have separate thread for each problem. So that it will be easy for people who are looking for solutions.

Thanks,
Vijay

• RELEVANCY SCORE 2.29

## DB:2.29:Db Link To Select Only One Table kc

Dear all,

I want to create a DB link in my local DB to access only one table in the remote DB .

User a in local DB

User y in remote DB ..Y has got 200 tables..

Can I create a DB link in my local DB as user a and access only one table in remote DB (Y schema)

Is this possible ?

Please let me know If I didn't make this clear ?

Kai

## DB:2.29:Db Link To Select Only One Table kc

Thanks a lot Sybrand

Kai

• RELEVANCY SCORE 2.29

## DB:2.29:Extracting Only One Record From Access Db k8

... hi

i am building a small DB application... inwhich i have to extract only

one record from ( either first or last one ) from Access DB ....

and as soon as i extract it from db i have to delete that row from

the db...

does any one know how to do it....

## DB:2.29:Extracting Only One Record From Access Db k8

Delete processing in SQL is not positional (neither is select, generally speaking). When you issue a delete, you basically issue a select statement, but tell the database to delete all the rows in the result set. Here is a small JDBC program that deletes data. In this program, I issue a select to get the value of the column in the row that I want to delete. This isn't strictly necessary, but you said that you wanted to get the value before you deleted it. After I get the value, I use it for the delete.

I'm making a couple of assumptions here (OK maybe more than a couple). The first is that the selected column value uniquly identifies the row I want to delete (only you can know if this is true). You may have to use more than a single column to get a unique key value for you delete. The second is that you can find your row using MIN, MAX, or some other statement that will return a single row for you to process.

I just pieced this together, so it may not be 100%, but it should get you started. Hope this helps you! If you get stuck, I'll try and answer if I can...:

String col1 = new String();
Strong url = new String(); // ODBC name
String userName = new String(); // probably optional with Access
String password = new String(); // probably optional with Access
//
// Connect to the Access database
//
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//
// Create the SQL (Select) Statement
//
Statement stmt = connection.createStatement();
String sql = "SELECT MAX(COL1) FROM TABLE_A";
//
// Execute the Query
//
ResultSet rs = stmt.executeQuery(sql);
//
// Loop through the Query ResultSet.
// There should only be 1 row because of the MAX(COL1).
// You may want to put in some error checking to be sure
// you actually found a row before attempting to delete one.
//
while(rs.next()) {
col1 = rs.getString(rs.findColumn("COL1"));
}
//
// Close the Statement when done.
//
stmt.close();
//
// Create the SQL (Delete) Statement. Access may use
// different quoting, maybe with escape characters.
//
Statement stmt = connection.createStatement();
String sql = "DELETE TABLE_A WHERE COL1 = '"+col1+"'";
//
// Execute the Delete. rowcnt is how many rows
// have been deleted.
//
int rowcnt = stmt.executeUpdate(sql);
//
// Commit the deletes. May not be necessary if you
// are using autocommit.
//
commit();
//
// Close the SQL Statement and Connection when done.
//
stmt.close();
connection.close();